Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: calculation with's date
I believe a (date - date) returns the difference in days.
You need to multiply the result by 60*60*24
Rob
Thomas wrote in message <6e366956.0109200629.53a8163a_at_posting.google.com>...
>Hello,
>
>is it possible to substract two date-format columns and get the
>correct amount of seconds
>
>regards
>Thomas
Received on Thu Sep 20 2001 - 09:55:27 CDT