Subtracting dates, any help is welcome
From: J. van der Laan <jan_at_nl.uu.net>
Date: Wed, 15 Jul 1998 11:46:02 +0200
Message-ID: <35AC7A59.6BA5DE2C_at_nl.uu.net>
Hello,
Date: Wed, 15 Jul 1998 11:46:02 +0200
Message-ID: <35AC7A59.6BA5DE2C_at_nl.uu.net>
Hello,
[Quoted] [Quoted] Surely this is pretty simple....but how simple it is I do not know.
I want to subtract two dates from eachother and want the output to be in hours/minutes/seconds.
The only thing I did achieve until now is;
SQL statement;
# select sum(out_time-in_time) from database where field=value;
Output;
SUM(OUT_TIME-IN_TIME)
.053784722
What does this output value say/mean???
btw; The OUT_TIME and IN_TIME fields are of type DATE.
Thanks in advance,
Jan. Received on Wed Jul 15 1998 - 11:46:02 CEST