How to get the first and last date of the current year in SQL

SELECT
   DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0) AS StartOfYear,
   DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) + 1, -1) AS LastDayOfYear,
   DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) + 1, 0) AS FirstOfNextYear,
   DATEADD(ms, -3, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) + 1, 0)) AS LastTimeOfYear

Thanks to Jamie F for the answer.

How to enable, disable and check if Service Broker is enabled on a database in SQL Server

How to return only the Date part from SQL Server DateTime datatype

Rename column SQL Server

Database stuck in “Restoring” state

Post Views: 11