看起来算是自动补上 00:00:00 然后左右闭合
附带测试数据:
2022-04-29 23:59:59
2022-04-30 00:00:00
2022-04-30 23:59:59
2022-05-01 00:00:00
2022-05-01 23:59:59
2022-05-02 00:00:00
SELECT * FROM `sc_tmp_test` where date BETWEEN "2022-04-30 00:00:00" and "2022-05-01 00:00:00" order by date
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~