Re: Adding dates in ORACLE?
Date: 1995/11/10
Message-ID: <1995Nov10.155454.35512_at_ucl.ac.uk>#1/1
In article <47bep1$gka_at_su102w.ess.harris.com>,
tgillesp_at_ms13.mis.semi.harris.com says...
>
>
>Can anyone please tell me how to add dates using SQL in ORACLE ?
>I've looked in the SQL ref. guide to no avail.
>I simply want to read a date from a table (eg. 20-OCT-95) then
>add one week to it (or 7 days, or 168 hours, etc) to get 27-OCT-95.
>
>Thanks ahead.
>
>--
> Tom Gillespie - -
> Harris Semiconductor | | | |
> Manufacturing Systems _/\/\/\/
> Palm Bay, FL | | | |
> Tom.Gillespie_at_harris.com _ _
>
> E Pluribus UNIX
According to the SQL Language reference manual (p 2-28) it says
that you can add and subtract numbers as well as other dates from dates.
e.g. SYSDATE + 1 would be tomorrow, and SYSDATE + 7 would be next week.
However you can't multiply or divide.
Hope this helps.
Bev Williams Received on Fri Nov 10 1995 - 00:00:00 CET