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,

[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

Original text of this message