OraFAQ Forum: Forms » Function that Return Previous Month of current date

Home » Developer & Programmer » Forms » Function that Return Previous Month of current date

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Function that Return Previous Month of current date [message #300122]

Thu, 14 February 2008 05:15

azamkhan
Messages: 557
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

Report message to a moderator

Re: Function that Return Previous Month of current date [message #300130 is a reply to message #300122]

Thu, 14 February 2008 05:38

sasipalarivattom
Messages: 121
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...

Report message to a moderator

Re: Function that Return Previous Month of current date [message #300133 is a reply to message #300130]

Thu, 14 February 2008 05:47

azamkhan
Messages: 557
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 08:30:19 CDT 2024