2,507
社区成员
发帖
与我相关
我的任务
分享一条SQL语句，看看是否有什么问题，谢谢
SELECT * FROM RKZ WHERE time BETWEEN 2003-04-24 AND 2003-04-27
执行后为何不返回RKZ表内24日到27日之间的纪录？我确定有这样的纪录存在,而且是Datetime类型的
执行后为何不返回RKZ表内24日到27日之间的纪录？我确定有这样的纪录存在,而且是Datetime类型的
...全文
请发表友善的回复…
发表回复
tobelost 2003-04-28
- 打赏
- 举报
SELECT * FROM RKZ WHERE time BETWEEN '2003-04-24' AND '2003-04-27'
rlongriver 2003-04-28
- 打赏
- 举报
UP
SELECT * FROM RKZ WHERE time BETWEEN '2003-04-24' AND '2003-04-27'
SELECT * FROM RKZ WHERE time BETWEEN '2003-04-24' AND '2003-04-27'
samcrm 2003-04-28
- 打赏
- 举报
用什么后台数据库？
Access必须这样：
SELECT * FROM RKZ WHERE time BETWEEN #2003-04-24# AND #2003-04-27#
Access必须这样：
SELECT * FROM RKZ WHERE time BETWEEN #2003-04-24# AND #2003-04-27#
lonelylight 2003-04-28
- 打赏
- 举报
SELECT * FROM RKZ WHERE time BETWEEN ;2003-04-24' AND '2003-04-27'
