我已经忙了好几个小时了,但我不能让它工作.
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
相差25小时.但我得到的输出是1(天).
如何获得25小时的输出?
我已经忙了好几个小时了,但我不能让它工作.
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
相差25小时.但我得到的输出是1(天).
如何获得25小时的输出?
用TIMESTAMPDIFF怎么样?
SELECT TIMESTAMPDIFF(HOUR, start_time, end_time)
as `difference` FROM timeattendance WHERE timeattendance_id = '1484'