where datetime > '2003-3-12' and datetime < '2003-3-13' where datetime between '2003-3-12' and < '2003-3-13'
access中: where datetime between # 2003-3-12 # and # 2003-3-13 # sql中: where datetime between '2003-3-12' and '2003-3-13'
select * from table_name where apply_time > '2003-03-01' and apply_time < '2003-03-13'select * from table_name where apply_time between '2003-03-01' and '2003-03-13'
时间不建议用between 用select * from 表 where 时间>=@开始时间 and 时间<=@结束时间
where datetime between '2003-3-12' and < '2003-3-13'
where datetime between # 2003-3-12 # and # 2003-3-13 #
sql中:
where datetime between '2003-3-12' and '2003-3-13'
where apply_time > '2003-03-01'
and apply_time < '2003-03-13'select * from table_name
where apply_time
between '2003-03-01' and '2003-03-13'
其他情况一样。