34,587
社区成员
发帖
与我相关
我的任务
分享
--try this
select * from t
where cdate between '2015-07-31 23:59:59' and convert(varchar(100),getdate(),120)
-- 到分秒的话,在时间后写就可以了,如果没有写默认是 00:00:00
select * from t
where cdate between '2015-08-01 12:05:13' and getdate()
-- 是这个意思吗 ?
select * from t
where cdate between '2015-08-01' and getdate()