在MySQL中得到两个日期时间的差值

TIME_TO_SEC(end_time)-TIME_TO_SEC(start_time) 与HOUR函数得到的结果都不全正确

---------------------------------------------------------------

#两日期/时间之间相差的天数:
To_Days(end_time)-To_Days(start_time)

#两日期/时间之间相差的秒数:
SELECT UNIX_TIMESTAMP(end_time)- UNIX_TIMESTAMP(start_time);

#两日期/时间之间相差的时分数:

SELECT SEC_TO_TIME(UNIX_TIMESTAMP(end_time)- UNIX_TIMESTAMP(start_time));

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus