查询每天的某个时间段的数据

nychenlei

mysql> select * from alert_mobile_history_log where alertId=192 limit 1;
+------+---------+--------+---------------------+
| id   | alertId | value  | createTime          |
+------+---------+--------+---------------------+
| 4048 |     192 |  10.29 | 2009-07-21 12:35:03 |
+------+---------+--------+---------------------+
1 row in set (0.00 sec)


mysql> select * from alert_mobile_history_log where alertId=192 and date_format(createTime, '%H:%i:%s')>'18:00:00' and date_format(createTime, '%H:%i:%s')

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u3/101226/showart_2018151.html