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: 65144
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: Reset table data after a process
Next Topic: to recompile java objects
Goto Forum:
  


Current Time: Sun Aug 20 03:03:52 CDT 2017

Total time taken to generate the page: 0.11190 seconds