return last month

#1

sorry to have to ask this.

How do I return last month in mm format?

For example it's November 8th Today. I'd like to get 10 back. If it
were January 8th, i'd like to get 12 back.

Thanks.

#2

"jobs" <jobs (AT) webdos (DOT) com> wrote

Quote:

sorry to have to ask this.

How do I return last month in mm format?

For example it's November 8th Today. I'd like to get 10 back. If it
were January 8th, i'd like to get 12 back.

Thanks.

Take a look at the add_months() function, e.g.:
select to_char(add_months(sysdate,-1),'mm') from dual
--
Terry Dykstra

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

return last month

comp.databases.oracle.misc comp.databases.oracle.misc

return last month - 11-08-2007 , 04:41 PM

Re: return last month - 11-08-2007 , 05:02 PM