How to bring the months? [message #413723] |
Fri, 17 July 2009 05:58  |
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 #413737 is a reply to message #413726] |
Fri, 17 July 2009 07:36   |
joy_division
Messages: 4963 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 #414077 is a reply to message #413883] |
Mon, 20 July 2009 05:19   |
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 #414213 is a reply to message #414180] |
Tue, 21 July 2009 00:50  |
pablolee
Messages: 2882 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?
|
|
|
|