Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: subtracting datetimes?
The difference is the number of days and fractions thereof. So multiply the
result by the number of seconds in a day (60*60*24)
Jim
"Michiel Brunt" <mbrunt_at_inergy.nl> wrote in message
news:9prvea$233g$1_at_scavenger.euro.net...
> I would like know the difference between two datetime field.
> Substracting the two gives me a very small number, but what should I do to
> turn it to the number of seconds between the two dates?
> Regards, Michiel
>
>
Received on Mon Oct 08 2001 - 07:41:30 CDT
![]() |
![]() |