Adding dates in ORACLE?

From: Mr. Tom Gillespie <tgillesp_at_ms13.mis.semi.harris.com>
Date: 1995/11/02
Message-ID: <47bep1$gka_at_su102w.ess.harris.com>#1/1

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

Received on Thu Nov 02 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Lang Richard: "Re: Saving Print Setup Options in Reports 2.5"
Previous message: - jack: "SQL loader for PO7"
Next in thread: Bev: "Re: Adding dates in ORACLE?"
Reply: Michael Tharp: "Re: Adding dates in ORACLE?"
Reply: lfeges_at_lfeges.tor.hookup.net: "Re: Adding dates in ORACLE?"
Reply: Bev: "Re: Adding dates in ORACLE?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message