# 两日期/时间之间相差的天数:
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));
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));
-> - TIME_TO_SEC(EXTRACT(HOUR_SECOND FROM'2003-03-04 23:00:00')) AS SEC;
+------+
| SEC |
+------+
| 60 |
+------+
1 row in set (0.00 sec)