Re: Comparing Time

Brian Neary skrev i meddelandet ...
>PLSQL: How do I add 3 seconds to a date field and how do I determine the
>difference in seconds between two date fields.
>
>
I don't have Oracle here at home. But you get a hang of what to do if you do this:

SELECT SYSDATE - TRUNC(SYSDATE) FROM DUAL; I guess that you will get todays time in a decimal number. So...3 seconds, that is 3/24*60*60 = 0.0000347. So adding that number to sysdate would get you 3 seconds ahead. I guess...Cant try it unfortunately.

Lars Received on Tue Nov 09 1999 - 20:31:50 CET