Only show hours in MYSQL DATEDIFF

datediff, mysql, sql

Solution

What about using TIMESTAMPDIFF?

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

Problem

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?

Original source