select * from mytable where datediff(day,cast(time as datetime),getdate())>=3
select * from mytable where time<convert(varchar(10),getdate()-3,120)
select * from tb where datediff(convert(datetime,[time],112),getdate())<=3
楼上的貌似需要修改下SELECT * FROM tb WHERE DATEDIFF(DAY,CONVERT(datetime,[time],112),getdate())<=3
thank you~! 再问一下,什么数据库都可以用吗?
--sql server select * from tb where datediff(day , time , getdate()) <= 3--oracle select * from tb where ceil(sysdate - To_date(time, 'yyyy-mm-dd hh24-mi-ss')) <= 3
where datediff(day,cast(time as datetime),getdate())>=3
再问一下,什么数据库都可以用吗?
select * from tb where datediff(day , time , getdate()) <= 3--oracle
select * from tb where ceil(sysdate - To_date(time, 'yyyy-mm-dd hh24-mi-ss')) <= 3