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?