Re: Help needed with Date Functions

date1 - date2 gives you the number of days between two dates, therefore 24 * 3600 * (sysdate - trunc(sysdate, 'MONTH')) gives you the number of seconds elapsed within the current month

Dieter

Paul Wiles schrieb:

> Hi
>
> Can someone tell me how to find the difference in seconds between two
> dates - is there an equivalent to the Transact SQL function:
>
> datediff(ss,date1,date2).
>
Received on Mon Apr 19 1999 - 07:31:59 CDT