OraFAQ Forum: SQL & PL/SQL » add 45 days in a sysdate.

Home » SQL & PL/SQL » SQL & PL/SQL » add 45 days in a sysdate.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

add 45 days in a sysdate. [message #10576]

Sat, 31 January 2004 19:03

shahzad-ul-hasan
Messages: 615
Registered: August 2002

Senior Member

dear
i want to add number(45) days into sysdate....
pls help me
example

sysdate numbers to add result
12-jan-04 45 29-mar-04
29-mar-04 60 30-jun-04
i want to get the required result......
thx

Report message to a moderator

Re: add 45 days in a sysdate. [message #10577 is a reply to message #10576]

Sat, 31 January 2004 19:35

Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA

Senior Member

SYSDATE is today's date. Is this what you want?:

scott@ORA92> SELECT SYSDATE, 45 AS "NUMBERS TO ADD", SYSDATE + 45 AS RESULT
  2  FROM   DUAL
  3  /

SYSDATE   NUMBERS TO ADD RESULT
--------- -------------- ---------
31-jan-04             45 16-mar-04

Report message to a moderator

Previous Topic:	Co-related sub queries
Next Topic:	add number into sysdate.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 16:33:44 CDT 2024