7,714
社区成员
发帖
与我相关
我的任务
分享ACCESS中如何查询一段时间之间的数据？
为什么我的这个语句执行会出错，应该怎么改呢？
SELECT * FROM [tbl_person] WHERE regist_time BETWEEN '2011-07-20 12:20:20' AND '2011-08-20 12:20:20'
SELECT * FROM [tbl_person] WHERE regist_time BETWEEN '2011-07-20 12:20:20' AND '2011-08-20 12:20:20'
...全文
请发表友善的回复…
发表回复
King_hhuang 2011-08-20
- 打赏
- 举报
谢谢
也可以这样
SELECT * FROM [tbl_person] WHERE regist_time BETWEEN #2011-07-20 12:20:20# AND #2011-08-20 12:20:20#
也可以这样
SELECT * FROM [tbl_person] WHERE regist_time BETWEEN #2011-07-20 12:20:20# AND #2011-08-20 12:20:20#
zetee 2011-08-20
- 打赏
- 举报
SELECT * FROM [tbl_person] WHERE regist_time>= #2011-07-20 12:20:20# AND regist_time<= #2011-08-20 12:20:20#
