Re: Help needed with Date functions

From: Matthew Son <esmks_at_email.ais.unc.edu>
Date: Mon, 19 Apr 1999 16:44:14 -0400
Message-ID: <371B959E.E7DB886F@email.ais.unc.edu>

You can do date arithmetic.

Date2 - Date1

will return the Number of days between Date1 and Date2.

Paul Davies wrote:
>
> Hi
>
> I'm new to Oracle from Sybase and am trying to work out how to find the
> difference in days between two dates. In Sybase there is a simple function
> datediff(dd,date1,date2). There appears to be no such function in Oracle.
>
> Does anyone know of a simple way to do this? Any more sophisticated date
> functions I can use?
>
> Thanks
>
> Paul
Received on Mon Apr 19 1999 - 15:44:14 CDT