sql - Only show hours in MYSQL DATEDIFF

Question

I've been busy with this for hours, but I cant get it to work.

SQL

SELECT DATEDIFF(end_time, start_time) as `difference` FROM timeattendance WHERE timeattendance_id = '1484'

start_time =   2012-01-01   12:00:00
end_time =     2012-01-02   13:00:00

The difference is 25 (hours). But the output I get is 1 (day).

How can I get the 25 hours as output?

Answer 1

What about using TIMESTAMPDIFF?

SELECT TIMESTAMPDIFF(HOUR, start_time, end_time) 
           as `difference` FROM timeattendance WHERE timeattendance_id = '1484'