SQL各种日期计算方法

SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)  --计算一个月第一天
SELECT DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)  --本周的星期一
SELECT DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)  --本年的第一天
SELECT DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)  --本季度的第一天

SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0))   --上个月最后一天
SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0)) --本月的最后一天
select DATEADD(wk, DATEDIFF(wk,0,dateadd(dd,6-datepart(day,getdate()),getdate())), 0) --本月的第一个星期一

select datename(weekday,getdate()) --显示星期几

--取得某月的天数
declare @m int
set @m=2 --月份
select datediff(day,'2008-'+cast(@m as varchar)+'-15' ,'2008-'+cast(@m+1 as varchar)+'-15')

--取得本月天数
select datediff(day,cast(month(GetDate()) as varchar)+'-'+cast(month(GetDate()) as varchar)+'-15' ,cast(month(GetDate()) as varchar)+'-'+cast(month(GetDate())+1 as varchar)+'-15')
SELECT Day(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0)))

--一个季度的天数
declare @m tinyint,@time smalldatetime
select @m=month(getdate())
select @m=case when @m between 1 and 3 then 1
when @m between 4 and 6 then 4
when @m between 7 and 9 then 7
else 10 end
select @time=datename(year,getdate())+'-'+convert(varchar(10),@m)+'-01'
select datediff(day,@time,dateadd(mm,3,@time))