Home » Developer & Programmer » Forms » Function that Return Previous Month of current date
Function that Return Previous Month of current date [message #300122] Thu, 14 February 2008 05:15 Go to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear Friends,

I am looking for a function that returns the PREVIOUS MONTH of CURRENT DATE/SYSDATE

Is there such function?

Regards,
Azam Khan
Re: Function that Return Previous Month of current date [message #300130 is a reply to message #300122] Thu, 14 February 2008 05:38 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Hi Mr. Azam,

I was also having such a requirement and i search for such a function. But unfortunately i didn't get one like that.
Then I tried another method It was like this..

select to_char(add_months(sysdate,-1),'MONTH') lastmonth 
from dual


I think this may help you.
However if you get any other simple method, Please share it..

Thanks and Regards
Sasi...
icon6.gif  Re: Function that Return Previous Month of current date [message #300133 is a reply to message #300130] Thu, 14 February 2008 05:47 Go to previous message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear Sasiiiii.... Smile
Thankssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss alot

Regards,
Azam Khan

[Updated on: Thu, 14 February 2008 05:48]

Report message to a moderator

Previous Topic: How to change font color & font size at runtime
Next Topic: Bad bind variable error
Goto Forum:
  


Current Time: Wed Dec 07 22:38:42 CST 2016

Total time taken to generate the page: 0.08496 seconds