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

Home -> Community -> Usenet -> c.d.o.server -> Re: subtracting datetimes?

Re: subtracting datetimes?

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Mon, 08 Oct 2001 12:41:30 GMT
Message-ID: <_9hw7.19160$JN.68843@news1.sttls1.wa.home.com>


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

Original text of this message

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