SQLServer查询本周 本月记录

SQLServer查询本周

sql 查询本周本月问题
---求相差天数
select?? datediff(day,'2004-01-01',getdate())?????
???
--1.一个月第一天的
Select?? DATEADD(mm,?? DATEDIFF(mm,getdate()),?? 0)
 ??
--2.本周的星期一
Select?? DATEADD(wk,?? DATEDIFF(wk,?? 0)
???
select?? dateadd(wk,datediff(wk,6)
--3.一年的第一天
Select?? DATEADD(yy,?? DATEDIFF(yy,?? 0)
???
--4.季度的第一天
Select?? DATEADD(qq,?? DATEDIFF(qq,?? 0)
???
--5.当天的半夜
Select?? DATEADD(dd,?? DATEDIFF(dd,?? 0)
???
--6.上个月的最后一天
Select?? dateadd(ms,-3,DATEADD(mm,?? 0))
???
--7.去年的最后一天
Select?? dateadd(ms,DATEADD(yy,?? 0))
???
--8.本月的最后一天
Select?? dateadd(ms,?? DATEDIFF(m,getdate())+1,?? 0))
???
--9.本年的最后一天
Select?? dateadd(ms,?? 0))
???
--10.本月的第一个星期一
select?? DATEADD(wk,
DATEDIFF(wk,dateadd(dd,6-datepart(day,getdate())),?? 0)

--查询本周注册人数
select?? count(*)?? from?? [user]
where?? datediff(week,create_day-1,getdate())=0
???
--上周注册人数
select?? count(*)?? from?? [user]
where?? datediff(week,getdate())=1
???
???
--本月注册人数
select?? count(*)?? from?? [user]
where?? datediff(month,create_day,getdate())=0
???
--上月注册人数
select?? count(*)?? from?? [user]
where?? datediff(month,getdate())=1

--如果要效率,这样写查询
???
--查询本周注册人数
select?? count(*)?? from?? [user]
where?? create_day>=dateadd(day,2-datepart(weekday,convert(varchar,getdate(),112))
and?? create_day???
--上周注册人数
select?? count(*)?? from?? [user]
where?? create_day>=dateadd(day,-5-datepart(weekday,112))
and?? create_day???
???
--本月注册人数
select?? count(*)?? from?? [user]
where?? create_day>=dateadd(day,1-day(getdate()),112))
and?? create_day???
--上月注册人数
select?? count(*)?? from?? [user]
where?? create_day>=dateadd(month,-1,dateadd(day,112)))
and?? create_day
--本周
select?? count(*)?? from?? User
where?? datediff(dd,getdate())?? <=?? datepart(dw,getdate())
???????
--上周
select?? count(*)?? from?? User
where?? datediff(dd,(getdate()?? -?? datepart(dw,getdate())))?? <=?? 7
???
--本月
select?? count(*)?? from?? User
where?? datepart(mm,create_day)?? =?? datepart(mm,getdate())
--上月
select?? count(*)?? from?? User
where?? datepart(mm,getdate())?? -?? 1
--本周
select?? count(*)?? from?? [User]
where?? datediff(dd,getdate())
???????
--上周
select?? count(*)?? from?? [User]
where?? datediff(dd,getdate())))?? <=?? 7
???
--本月
select?? count(*)?? from?? [User]
where?? datepart(mm,getdate())
--上月
select?? count(*)?? from?? [User]
where?? datepart(mm,getdate())?? -?? 1
学习
month(create_day)=month(getdate())本月
month(create_day)=month(getdate())-1?? 上月

补充 查询今日所有的 Select * from feedback Where (DATEDIFF(d,fedtime,GETDATE())=0) orDER BY fedid DESC

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!