add_months [message #36538] |
Mon, 03 December 2001 16:55 |
cher
Messages: 1 Registered: December 2001
|
Junior Member |
|
|
Is there an opposite to add_months? I want to select data for the last rolling 12 months. Thanks
----------------------------------------------------------------------
|
|
|
Re: add_months [message #36539 is a reply to message #36538] |
Tue, 04 December 2001 00:46 |
Pratibha
Messages: 29 Registered: November 2001
|
Junior Member |
|
|
Hi,
U can use add_months only like this
select add_months(sysdate,-12) from dual;
where -12 is the no. of months.
this will substract -12 months from system date.
Bye
----------------------------------------------------------------------
|
|
|