OraFAQ Forum: SQL & PL/SQL » Substract one year of sysdate

Home » SQL & PL/SQL » SQL & PL/SQL » Substract one year of sysdate

Wed, 27 February 2002 23:57

Antoni
Messages: 8
Registered: February 2002

Junior Member

HI
I WOULD LIKE TO KNOW HOW TO SUBSTRACT ONE YEAR TO THE SYSDATE

IE: TODAY IS 02/28/2002 I WANT 02/28/2001

THANKS A LOT

Thu, 28 February 2002 01:13

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

select add_months(sysdate,-12) from dual;
OR
select sysdate-365 from dual;

Previous Topic:	dbms_utility.get_time
Next Topic:	Query ?

Goto Forum:

]

Current Time: Fri Apr 19 22:33:27 CDT 2024