Home » SQL & PL/SQL » SQL & PL/SQL » Equivalent of dateadd(MS Acess) in oracle (Oracle 10)
icon8.gif  Equivalent of dateadd(MS Acess) in oracle [message #328341] Thu, 19 June 2008 16:06 Go to next message
sumanth27
Messages: 2
Registered: June 2008
Junior Member
I want the equivalent of
(DateAdd("s",[OBJ_M_DOCUMENTS.M_DOC_N_DATE],"12/15/1970")) which is Acess in oracle.

[OBJ_M_DOCUMENTS.M_DOC_N_DATE] is the column name.

Re: Equivalent of dateadd(MS Acess) in oracle [message #328342 is a reply to message #328341] Thu, 19 June 2008 16:11 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

If you had posted this in an Access forum, you'd have higher odds that somebody would understand the requirements.

Since you decided that we did not need to be told the requirement in English, You're On Your Own (YOYO)!
Re: Equivalent of dateadd(MS Acess) in oracle [message #328343 is a reply to message #328341] Thu, 19 June 2008 16:37 Go to previous messageGo to next message
sumanth27
Messages: 2
Registered: June 2008
Junior Member
I am sorry about asking the MS Access fuction. But Can anyone help me with date functions. Is there any function where we can add a date field like dateadd.
Re: Equivalent of dateadd(MS Acess) in oracle [message #328345 is a reply to message #328343] Thu, 19 June 2008 16:49 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Oracle uses simple date arithmetic for this i.e
a_date+1 (add 1 day)
a_date-1 (subtract 1 day)
a_date+1/24 (add 1 hour)
a_date+1/1440 (add 1 minute)
For specifics, you could always go out on a limb and read the fine manuals at http://tahiti.oracle.com
Re: Equivalent of dateadd(MS Acess) in oracle [message #328347 is a reply to message #328341] Thu, 19 June 2008 16:52 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
In Oracle no function is needed to add to a date datatype.
SYSDATE+30 give the date 30 days in the future.
Hope This Helps!
Previous Topic: to drop a user
Next Topic: How to check inserted records so far while executing a insert statement.
Goto Forum:
  


Current Time: Sat Dec 10 04:50:43 CST 2016

Total time taken to generate the page: 0.08947 seconds