SQL【查询某时间段范围内的数据】

1. between

select * from position_info where ZPKSSJ BETWEEN '20220301000000' and '20220426000000'

2. > , <

select * from position_info where ZPKSSJ >= '20220301000000' and ZPKSSJ <= '20220426000000'

注意

between…and 包含时间界限，相当于<=,>=

版权声明：本文为m0_46459413原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。

原文链接：https://blog.csdn.net/m0_46459413/article/details/124413454