SQL Date Types

SQL Date Types

by lokointhehouse2

HTML

-- TIMES
				Declare @thisweek datetime
				Declare @thismonth varchar(50)
				Declare @lastmonth varchar(50)
				Declare @thisquarter  varchar(50)
				Declare @lastquarter varchar(50)
				Declare @lastquarteryear varchar(50)
				Declare @year varchar(50)
				Declare @reportdt int

				set @thisweek=DATEADD(wk, DATEDIFF(wk,0,GETDATE()), -1)-14
				set @thismonth=DATENAME(MONTH, getdate())
				set @lastmonth=DATENAME(MONTH, DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)-1)
				set @thisquarter=DATEPART(QUARTER, getdate())
				set @lastquarter=DATEPART(QUARTER,   Dateadd(qq, Datediff(qq,0,GetDate())-1, 0))
				set @lastquarteryear=DATEPART(YEAR,   Dateadd(qq, Datediff(qq,0,GetDate())-1, 0))
				set @year=DATEPART(yyyy, getdate())
				-- /TIMES