select * from table where 时间>='2010-8-10' and 时间 <= '2010-8-30'
select * from table where 时间>='2010-8-10' and 时间 <= '2010-8-30'
DateTime dt = DateTime.Now.AddDays(-20);Select * from TableName where Cdate >= @Cdate;//@Cdate即dt
select * from table where dateadd(d,时间,getdate())<=20
SELECT * FROM dbo.t_CardList WHERE UsefulTime > GetDate()-20
select * from table where 时间> sysdate-20 系统时间减去20天
select * from mytable where yourTime between datediff(day,-20,getdate())and getdate() select dateadd(day,-20,getdate()) , getdate()
select * from table where 时间>='2010-8-10' and 时间 <= '2010-8-30' 这是通过SQL语句直接查询 select * from table where dateadd(d,时间,getdate())<=20dataadd函数使用,通用时间查询函数很多,可以充分达到你的需求。SQL帮助文档中一大堆,你可以去看下
30天以内:select * from 表名 where datediff(day,日期字段名,getdate())<30
select * from sales where ord_date<=getdate() and ord_date>=dateadd(day,-10,getdate())
select * from table where dateadd(d,时间,getdate())<=20
select * from titles where datediff(year,mydate,getdate()) <= 20
select * from table where 时间> sysdate-20
select * from table where 你的时间字段>=DATEADD(dd,-20,getdate())
系统时间减去20天
select dateadd(day,-20,getdate()) , getdate()
这是通过SQL语句直接查询
select * from table where dateadd(d,时间,getdate())<=20dataadd函数使用,通用时间查询函数很多,可以充分达到你的需求。SQL帮助文档中一大堆,你可以去看下