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 包含时间界限,相当于<=,>=