| 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?
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
