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')<'23:59:59';
+------+---------+--------+---------------------+
| id | alertId | value | createTime |
+------+---------+--------+---------------------+
| 4070 | 192 | 26.11 | 2009-07-21 19:25:09 |
| 4073 | 192 | 5.48 | 2009-07-21 19:30:04 |
| 4075 | 192 | 20.55 | 2009-07-21 20:35:11 |
| 4076 | 192 | 6.74 | 2009-07-21 20:45:09 |
| 4077 | 192 | 13.73 | 2009-07-21 20:55:04 |
| 4157 | 192 | 10.74 | 2009-07-22 19:25:05 |
| 4371 | 192 | 19.12 | 2009-07-24 20:15:06 |
| 4372 | 192 | 14.63 | 2009-07-24 20:20:07 |
| 4373 | 192 | 6.97 | 2009-07-24 20:25:03 |
| 4374 | 192 | 24.56 | 2009-07-24 20:35:04 |
| 4375 | 192 | 18.51 | 2009-07-24 20:40:04 |
| 4376 | 192 | 16.80 | 2009-07-24 20:45:04 |
| 4377 | 192 | 22.77 | 2009-07-24 20:50:05 |
| 4415 | 192 | 8.99 | 2009-07-24 23:55:03 |
| 5487 | 192 | 8.60 | 2009-07-28 23:40:04 |
| 5759 | 192 | 18.83 | 2009-07-29 23:35:05 |
| 5888 | 192 | 5.04 | 2009-07-30 23:10:05 |
| 6153 | 192 | 15.00 | 2009-08-01 20:30:03 |
| 6154 | 192 | 6.85 | 2009-08-01 20:35:05 |
| 6163 | 192 | 6.38 | 2009-08-01 22:45:03 |
| 6300 | 192 | 5.33 | 2009-08-02 21:40:05 |
| 6574 | 192 | 6.28 | 2009-08-04 19:30:03 |
| 6575 | 192 | 20.71 | 2009-08-04 19:35:03 |
| 6576 | 192 | 36.36 | 2009-08-04 19:40:07 |
+------+---------+--------+---------------------+
24 rows in set (0.01 sec)
阅读(945) | 评论(0) | 转发(0) |