56,912
社区成员




mysql> select ftime from t_log_test;
+----------+
| ftime |
+----------+
| 15:07:05 |
| 15:26:38 |
| 15:26:38 |
| 15:26:38 |
| 15:26:38 |
mysql> select hour(ftime),minute(ftime),max(second(ftime)) from t_log_test group by hour(ftime),minute(ftime);
+-------------+---------------+--------------------+
| hour(ftime) | minute(ftime) | max(second(ftime)) |
+-------------+---------------+--------------------+
| 15 | 7 | 5 |
| 15 | 26 | 40 |
| 16 | 48 | 31 |
+-------------+---------------+--------------------+
select @time:='17:12:23', hour(@time), minute(@time), second(@time);