ASP sql 查询 当天 当月 上月 记录
- http://blog.gufang.org/
- 2016/3/30 6:49:20
- 来源:Gufang's Private Space
- 点击:
当天
SQL Server:
select top 10 * from test where day(AddTime)=day(getdate()) and year(AddTime)=year(getdate())
select * from test
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
发表评论(0)