Home » SQL & PL/SQL » SQL & PL/SQL » How to get the 7years back date based on the sysdate???
icon5.gif  How to get the 7years back date based on the sysdate??? [message #258084] Fri, 10 August 2007 02:50 Go to next message
arunsuresh100
Messages: 38
Registered: December 2006
Member
Hi everyone,
I need to get the following query......
How to get the 7years back date based on the sysdate???

Thanks and Regards,
arun
Re: How to get the 7years back date based on the sysdate??? [message #258088 is a reply to message #258084] Fri, 10 August 2007 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
add_months(sysdate, -7*12)

Regards
Michel
Re: How to get the 7years back date based on the sysdate??? [message #258093 is a reply to message #258088] Fri, 10 August 2007 03:09 Go to previous message
arunsuresh100
Messages: 38
Registered: December 2006
Member
Thanks Michel
Previous Topic: Tree Query Output
Next Topic: doubt on simple select
Goto Forum:
  


Current Time: Wed Dec 07 22:14:09 CST 2016

Total time taken to generate the page: 0.07783 seconds