Home » SQL & PL/SQL » SQL & PL/SQL » Getting date problem
Getting date problem [message #408881] Thu, 18 June 2009 02:53 Go to next message
Messages: 20
Registered: September 2008
Location: faridabad
Junior Member

i want to know six month previous date from today date

can anyone tell me


[EDITED by LF: Cross-posted topic moved in here from the Linux forum. Topics have then been merged and duplicate message has been deleted]

[Updated on: Thu, 18 June 2009 03:23] by Moderator

Report message to a moderator

Re: Getting date problem [message #408884 is a reply to message #408881] Thu, 18 June 2009 03:01 Go to previous messageGo to next message
Messages: 7062
Registered: December 2001
Senior Member
Have a look at ADD_MONTHS.

Re: getting date problem [message #408885 is a reply to message #408881] Thu, 18 June 2009 03:18 Go to previous message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It was January 18 2009.

Is your question Oracle related? If so, why did you put it into Linux forum?

ADD_MONTHS might help:
SQL> select add_months(sysdate, -6) from dual;

18.12.2008 10:17:53


[Updated on: Thu, 18 June 2009 03:19]

Report message to a moderator

Previous Topic: Query using REGEXP funtion
Next Topic: multiple insertion problem
Goto Forum:

Current Time: Sat Jul 22 19:59:18 CDT 2017

Total time taken to generate the page: 0.09373 seconds