Is there a dateadd() function?

From: Daniel Kosolofski <daniel.kosolofski_at_cgi.ca>
Date: Tue, 21 Jul 1998 14:47:40 GMT
Message-ID: <35B4AA9B.BB726DFB@cgi.ca>

I am used to using SQl Server and not
Oracle so I am not totaly familiar with the systax.

So on that note my question is how do
you add/subtract dates (specifically
hours) .
E.g. ('02/jun/1998 12:00 A.M' - 3 hours) I know in SQL Server there is a dateadd function.
Is there the same thing in oracle.

I am currently on holidays and have no
access to books so please send syntax or example. PLEASE!!

Thank You all for the help in advance!

--
Daniel Kosolofski
Consultant
CGI Information Systems and Management
Consultants Inc.
333 Seventh Avenue S.W.
Calgary, Alberta
Canada T2P 2Z1
Voice: (403) 233-2713
Fax: (403) 262-8236
Email: daniel.kosolofski_at_cgi.ca Received on Tue Jul 21 1998 - 09:47:40 CDT