Re: Subtracting dates, any help is welcome

Check out the following URL:

   http://www.edo.com/sacoug/developer2000/messages/969.html

It has a script I posted to do what you want.

Steve Cosner

In article <35AC7A59.6BA5DE2C_at_nl.uu.net>, J. van der Laan <jan_at_nl.uu.net> wrote:
>Hello,
>
>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 - 17:01:00 CEST