1.我感觉你是把数据结果搞混了吧?图1的SQL怎么会得到图2的输出,你都把test表的时间列格式化成以"-"为分割符,怎么输出会是"/"为分隔符?
2.像这种date_format()之后再比较时间的大小,其实是把时间当成字符串来比较,例如
mysql> select date_format('2019-12-12 23:54:12','%y-%m-%d');
+-----------------------------------------------+
| date_format('2019-12-12 23:54:12','%y-%m-%d') |
+-----------------------------------------------+
| 19-12-12 |
+-----------------------------------------------+
1 row in set (0.00 sec)
mysql> select date_format('2019-06-27','%y/%m/%d %h%i%s');
+---------------------------------------------+
| date_format('2019-06-27','%y/%m/%d %h%i%s') |
+---------------------------------------------+
| 19/06/27 120000 |
+------------------------