select * from table where date between date1 and date2
如果date1 = "2020/4/6",date2 = "2020/4/7",取值范围是date1零点到date2零点。
若要取date2一整天,可以在date2后面拼接 date2 = "2020/4/7"&" "&"23:59:59"(VBA中是这样拼接字符串,其他语言视情况而定)
select * from table where date between date1 and date2
如果date1 = "2020/4/6",date2 = "2020/4/7",取值范围是date1零点到date2零点。
若要取date2一整天,可以在date2后面拼接 date2 = "2020/4/7"&" "&"23:59:59"(VBA中是这样拼接字符串,其他语言视情况而定)