Re: Adding dates in ORACLE?

In article <47bep1$gka_at_su102w.ess.harris.com>, <tgillesp_at_ms13.mis.semi.harris.com> writes:
> Path:

noc.tor.hookup.net!nic.ott.hookup.net!hookup!usenet.eel.ufl.edu!usenet.cis.ufl. edu!usenet.ufl.edu!darwin.sura.net!jabba.ess.harris.com!news.ess.harris.com!ms1 3.mis.semi.harris.com!tgillesp
> From: tgillesp_at_ms13.mis.semi.harris.com ( Mr. Tom Gillespie)
> Newsgroups: comp.databases.oracle
> Subject: Adding dates in ORACLE?
> Date: 2 Nov 1995 21:55:45 GMT
> Organization: Harris Electronic System Sector
> Lines: 16
> Message-ID: <47bep1$gka_at_su102w.ess.harris.com>
> NNTP-Posting-Host: ms13.mis.semi.harris.com
> Mime-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> X-Newsreader: TIN [version 1.2 PL0]
>
>
> 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

How about:

select to_date('20-OCT-95') + 7 from DUAL?

Result:

27-OCT-95 \lfeges Received on Mon Nov 06 1995 - 00:00:00 CET