34,588
社区成员
发帖
与我相关
我的任务
分享
SELECT * from PassRecords where PassDate BETWEEN '2012-02-07 00:00:00' and '2012-02-09 23:59:59';
结果有154条,但是我自己看了一下这段时间内有800多条数据,为什么我只查到154条呢,求解。。。!!
SELECT *
from PassRecords
where PassDate
BETWEEN cast('2012-02-07 00:00:00' as datetime)
and cast('2012-02-09 23:59:59' as datetime);