Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Would like an end-date like: 2012-12-31 23:59:59.999
declare @dt datetime set @dt = GETDATE() declare @Calendar_Year_Start datetime declare @Calendar_Year_End datetime select @Calendar_Year_Start = DATEADD(yyyy, DATEDIFF(yyyy, 0, @dt), 0) ,@Calendar_Year_End = DATEADD(second,-1, DATEADD(year, 1, @Calendar_Year_Start)) select @Calendar_Year_Start as Calendar_Year_Start, @Calendar_Year_End as Calendar_Year_End Returns: 2012-01-01 00:00:00.000 2012-12-31 23:59:59.000
Join the community of 500,000 technology professionals and ask your questions.