mysql 查询最早 表_MySQL-如何查询表中最早时间和最晚时间

mysql里 varchar按字符从左到右作比较, 所以在这里用max, min就可以满足要求了.

mysql> select version();

+------------+

| version() |

+------------+

| 5.5.24-log |

+------------+

1 row in set (0.02 sec)

mysql> create table aaa(hour varchar(20));

Query OK, 0 rows affected (0.27 sec)

mysql> insert into aaa values('08:46:04'), ('18:13:52'), ('18:20:38'),('00:00:01'),('23:59:59');

Query OK, 5 rows affected (0.03 sec)

Records: 5 Duplicates: 0 Warnings: 0

mysql> select max(hour), min(hour) from aaa;

+-----------+-----------+

| max(hour) | min(hour) |

+-----------+-----------+

| 23:59:59 | 00:00:01 |

+-----------+-----------+

1 row in set (0.07 sec)