Home » Other » Training & Certification » increment months
increment months [message #289824] Wed, 26 December 2007 04:00 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
Hi All

i have dates

date

01-jan-2001
01-feb-2002
02-feb-2002
02-jan-2003


i want to output like this


mm
1
13
13
24

thanks
srinivas


Re: increment months [message #289850 is a reply to message #289824] Wed, 26 December 2007 04:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
MONTHS_BETWEEN

Regards
Michel
Re: increment months [message #289853 is a reply to message #289850] Wed, 26 December 2007 05:02 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
i did'nt understand michel
Re: increment months [message #289860 is a reply to message #289853] Wed, 26 December 2007 05:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You don't understand your question?

Regards
Michel

[Updated on: Wed, 26 December 2007 05:13]

Report message to a moderator

Re: increment months [message #289862 is a reply to message #289850] Wed, 26 December 2007 05:19 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member

just months_between

how it will be solved.
Re: increment months [message #289868 is a reply to message #289862] Wed, 26 December 2007 05:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Try to apply it.

By the way what is the question?

And after 240+ posts you still don't know the basic.
Read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Always post your Oracle version (4 decimals).

Regards
Michel
Re: increment months [message #289899 is a reply to message #289824] Wed, 26 December 2007 08:51 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Pavuluri, I've seen two questions you asked recently. Both of them look the same: "I have this, I want this". Although an example is a great thing, why do you expect us to decode what you meant to say? How much would it cost if you, actually, write several sentences and EXPLAIN your requirement?

For example, a problem you have in this topic: I must be quite stupid because I had to see Michel's suggestion and check your question again, calculate number of months between value you wrote and say "Oh! So that was the question!".

So, why don't you write a question like this: "I have a table with some date values (see the example). I need to calculate how many months are there between two dates. Could someone explain how to do that, please?"

Because, depending on current frame of mind, I'll simply skip your question and move on to one who can articulate his/her problem (and I believe I'm not the only one who does that). Michel is just too kind and is trying to help, even though you don't understand what you want and what he suggests.
Previous Topic: Conditionally display previous values
Next Topic: month and month number
Goto Forum:
  


Current Time: Sun Nov 24 04:05:41 CST 2024