Re: Subtracting dates, any help is welcome

In article <35AC7A59.6BA5DE2C_at_nl.uu.net>, "J. van der Laan" <jan_at_nl.uu.net> writes
>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.
>
>

Try

select to_char(sum(out_time-in_time),'HH:MI') from database where field=value;

           |    Andrew Hodgson - Andrew_at_tcamiga.demon.co.uk   |
           |                     www.tcamiga.demon.co.uk      |
           |  Amiga 1200 030 33Mhz    |       6x86 P150+      |
           | 250Mb HD   HD Disk Drive | Quad Spd CD 5.3 Gb HD |
           | 6Mb Ram | CDTV | Motorola SurfR 56K |  80Mb Ram  |
                           Resistance is futile...