Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help needed with Date functions

Re: Help needed with Date functions

From: David Ng <david_ng_at_attmysite.com>
Date: Wed, 21 Apr 1999 00:00:17 +0800
Message-ID: <371CA491.444A8049@attmysite.com>


Hi,

Simply date1 - date2. like

Select date1-date2 from dual ;

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 Tue Apr 20 1999 - 11:00:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US