Question

Access数据库 查询日期范围？

select * from table where datetime between 2013-01-01 and 2013-02-01

select * from table where datetime between '2013-01-01' and '2013-02-01'
select * from table where datetime between #2013-01-01# and #2013-02-01#
select * from table where datetime between '#2013-01-01#' and '#2013-02-01#'
select * from table where datetime >=2013-01-01 and datetime <=2013-02-01

select * from table where datetime >='2013-01-01' and datetime <='2013-02-01'
select * from table where datetime >=#2013-01-01# and datetime <=#2013-02-01#
select * from table where datetime >='#2013-01-01#' and datetime <='#2013-02-01#'

以上写法全部尝试过，都不可以！

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 语法错误 在查询表达式 '_time >= #2013/03/01 00:00:00# and _time <=#2013/03/07 23:59:59#' 中。

Answer 1

Access查询表条件中控制日期时间段的方法如下：
1、可以在查询时设置参数查询。
2、在查询的设计视图，执行“查询”菜单中的“参数”命令，在打开的“查询参数”对话框中定义参数及其数据类型（日期时间型），假设参数为D1、D2，然后在条件中输入：Between [D1] And [D2]

Answer 2

字段名，先修改一下，改成别的、不和datetime冲突的。
或者加[]号