|
上個(gè)月的第一天 SELECT DATEADD(mm,DATEDIFF(mm ,0,getdate())-1, 0) 上個(gè)月的最后一天 SELECTdateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)) 本月第一天 SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) 本季度第一天 SELECT DATEADD(qq, DATEDIFF(qq,0,getdate()), 0) 本周第一天 SELECT DATEADD(wk, DATEDIFF(wk,0,getdate()), 0) 今年第一天 SELECT DATEADD(yy, DATEDIFF(yy,0,getdate()), 0) 今天去掉時(shí)分秒 SELECT DATEADD(dd, DATEDIFF(dd,0,getdate()), 0) 本月最后一天 1、SELECT DATEADD(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1,0)) 2、SELECT DATEADD(dd,-day(getdate()),DATEADD(m,1,getdate())) 本月第一個(gè)星期一 select DATEADD(wk,DATEDIFF(wk,0,dateadd(dd,6-datepart(day,getdate()),getdate())),0) 上個(gè)月最后一天 SELECT DATEADD(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()),0)) 去年最后一天 SELECT DATEADD(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate()),0)) 去掉時(shí)分秒 declare @ datetime set @ = getdate() --'2003-7-1 10:00:00' SELECT @,DATEADD(day, DATEDIFF(day,0,@),0) 今天是星期幾 select datename(weekday,getdate()) 獲取某月天數(shù) declare @y varchar(8) declare @m int set @y='2004' set @m=2 --月份 select DATEDIFF(day,@y+'-'+cast(@m as varchar)+'-15',@y+'-'+cast(@m+1 as varchar)+'-15') 判斷是否閏年 SELECT case day(dateadd(mm,2,dateadd(ms,-3,DATEADD(yy,DATEDIFF(yy,0,getdate()), 0)))) when 28 then '平年' else '閏年'end --或者 select caseDATEDIFF(day,datename(year,getdate())+'-02-01',dateadd(mm,1,datename(year,getdate())+'-02-01')) when 28 then '平年' else '閏年' end 一個(gè)季度多少天 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)) |
|
|
