Datediff in Hours?

Merlinius · #1 (**permalink**) 01-28-09, 07:33

How can I subtract two datestamps (yyyy-mm-dd hh:mm:ss) to give the result in hours?

mike_bike_kite · #2 (**permalink**) 01-28-09, 08:23

Quote:

Originally Posted by Merlinius

How can I subtract two datestamps (yyyy-mm-dd hh:mm:ss) to give the result in hours?

You can convert both times to seconds using unix_timestamp. Then subtract one from other to get number of seconds between both times. Then divide by 3600 to get the number of hours ie
Code:
select ( unix_timestamp( "2008-01-28 10:00" ) - 
         unix_timestamp("2008-01-27 09:00" ) ) / 3600
Note that this only works if both dates are after 1970.

Merlinius · #3 (**permalink**) 01-28-09, 09:04

Quote:

Originally Posted by mike_bike_kite

You can convert both times to seconds using unix_timestamp. Then subtract one from other to get number of seconds between both times. Then divide by 3600 to get the number of hours ie
Code:
select ( unix_timestamp( "2008-01-28 10:00" ) - 
         unix_timestamp("2008-01-27 09:00" ) ) / 3600
Note that this only works if both dates are after 1970.

Nice one Mike

Internet Services

Web Development

Digital Marketing

Consumer Tech