subtracting two dates

[mhamilton3]

Hello all,
I have to subtract two dates and get the results in hours, minutes, and seconds. It seems like such a simple question, but I can not get things to come out the way I want them to. I am not on 4.1.1 yet (4.0.18) so I can not use the new functions. Any suggestions?

 

[Bastien]

are plannning a pure sql approach or are you willing to use application logic to do the calc?

Bastien

Cat, the other other white meat

 

[mhamilton3]

I'll take whatever I can get - post SQL calculations are cool with me if you have one. Thanks

 

[r937]

select sec_to_time(
time_to_sec(columna)
- time_to_sec(columnb)
) as elapsed_time

if the difference is greater than 24 hours, you will have to subtract whole days out first

(holler if you want the sql for that too)

rudy

http://r937.com/

SQL Consulting