ASP sql 查询 当天 当月 上月 记录

当天

SQL Server:

select top 10 * from test where day(AddTime)=day(getdate()) and year(AddTime)=year(getdate())
select * from test  where datediff(d,AddTime,getdate())=0

Access:

select top 10 * from test where day(AddTime)=day(Now()) and year(AddTime)=year(Now())

test是表，dateandtime是日期/时间字段

上月

select * from 表名 where datediff(month,日期字段,getdate())=1