1.首先明确BETWEEN AND 是报含左右边界的
效果等同于 login_time >='2022-01-01 00:00:00' and login_time<='2022-01-02 23:59:59'
认为同等效果 用BETWEEN AND 的另外一种错误写法
login_time BETWEEN '2022-01-01' AND '2022-01-03'
1.首先明确BETWEEN AND 是报含左右边界的
效果等同于 login_time >='2022-01-01 00:00:00' and login_time<='2022-01-02 23:59:59'
认为同等效果 用BETWEEN AND 的另外一种错误写法
login_time BETWEEN '2022-01-01' AND '2022-01-03'