Sql Server部分语句

查询今天

SELECT * FROM tablename where DATEDIFF(day,inputdate,GETDATE())=0

SELECT * FROM tablename where inputdate like convert(varchar(8),GETDATE(),112)


查询昨天
SELECT * FROM tablename where DATEDIFF(day,inputdate,GETDATE())=1


查询本周
SELECT * FROM tablename where datediff(week,inputdate,getdate())=0


查询上周
SELECT * FROM tablename where datediff(week,inputdate,getdate())=1


查询本月
SELECT * FROM tablename where DATEDIFF(month,inputdate,GETDATE())=0


查询上月
SELECT * FROM tablename where DATEDIFF(month,inputdate,GETDATE())=1

SELECT * FROM tablename where inputdate like convert(varchar(6),DATEADD(MONTH,-1,GETDATE()),112)

 

posted @ 2022-07-01 09:35  超级驼鹿  阅读(23)  评论(0)  编辑  收藏  举报
/*