Home » SQL & PL/SQL » SQL & PL/SQL » How to bring the months?
How to bring the months? [message #413723] Fri, 17 July 2009 05:58 Go to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
Hi,

I have one part column and ship_date and recive_date in my query.I want to display the data like "How many months each part recived ".How can i get the Month by using ship_date and recive date.Which function i want to use bring the month.

please help me.
Re: How to bring the months? [message #413724 is a reply to message #413723] Fri, 17 July 2009 06:02 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Would MONTHS_BETWEEN function help?
Re: How to bring the months? [message #413726 is a reply to message #413724] Fri, 17 July 2009 06:09 Go to previous messageGo to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
Thanks for Fast replay.

Can u please send the how to use this formula ?
Re: How to bring the months? [message #413727 is a reply to message #413726] Fri, 17 July 2009 06:19 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Would you like us to code and debug your whole application too?
Re: How to bring the months? [message #413737 is a reply to message #413726] Fri, 17 July 2009 07:36 Go to previous messageGo to next message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
tondapi wrote on Fri, 17 July 2009 07:09
Thanks for Fast replay.

Can u please send the how to use this formula ?



Oh no, not this bozo again. Notice in his profile what his "Interests" are? Another lazy freeloader we can add to that club.

So, you've been using Oracle at least 2 years, based on the date you registered, and you don't know something as basic as this? I think it's time to give up.

[Updated on: Fri, 17 July 2009 07:38]

Report message to a moderator

Re: How to bring the months? [message #413740 is a reply to message #413737] Fri, 17 July 2009 07:52 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
be fair - his interests are Searching, not Finding....
Cool
Re: How to bring the months? [message #413743 is a reply to message #413740] Fri, 17 July 2009 07:57 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
JRowbottom wrote on Fri, 17 July 2009 13:52
be fair - his interests are Searching, not Finding....
Cool


LMAO Laughing
Re: How to bring the months? [message #413863 is a reply to message #413723] Fri, 17 July 2009 20:46 Go to previous messageGo to next message
oracle909
Messages: 1
Registered: July 2009
Junior Member
Date1 - date2 / 30
Re: How to bring the months? [message #413883 is a reply to message #413863] Sat, 18 July 2009 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
oracle909 wrote on Sat, 18 July 2009 03:46
Date1 - date2 / 30

You get a F with this answer, even in primary school.

Regards
Michel

Re: How to bring the months? [message #414077 is a reply to message #413883] Mon, 20 July 2009 05:19 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Quote:
Date1 - date2 / 30

You get a F with this answer, even in primary school.


I'd be wiling to use it as a simple interview question - a 'how many things can you find wrong with this and how would you fix it' one.
Re: How to bring the months? [message #414180 is a reply to message #413723] Mon, 20 July 2009 14:05 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
use google and search on

"ORACLE MONTHS_BETWEEN"
Re: How to bring the months? [message #414213 is a reply to message #414180] Tue, 21 July 2009 00:50 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Bill B wrote on Mon, 20 July 2009 20:05
use google and search on

"ORACLE MONTHS_BETWEEN"

Already been said
Littlefoot wrote on Fri, 17 July 2009 12:02
Would MONTHS_BETWEEN function help?

Previous Topic: triggers
Next Topic: Reclaim allocated space to a table
Goto Forum:
  


Current Time: Wed Dec 07 04:43:35 CST 2016

Total time taken to generate the page: 0.12297 seconds