Inquiries at the beginning of the year, at the end of last years, early next year with the year-end SQL statement

--Annual calculation

DECLARE @date datetime
Set @date =getdate ()
--the first day of the year on which the given date is calculated
Select DATEADD (Year,datediff (year,0, @date), 0) as ' the first day of the year '
-Year-End, calculate the last day of the year for a given date
Select DATEADD (Year,datediff (year,-1, @date), -1) as ' The last day of the year '
--At the beginning of the previous year, calculate the first day of the Year of the year in which the given date
Select DATEADD (Year,datediff (year,-0, @date) -1,0) as ' the first day of the Year of the Year '
--At the end of the previous year, calculate the last day of the Year of the year in which the given date
Select DATEADD (Year,datediff (year,0, @date), -1) as ' The last day of the previous year of the Year '
--At the beginning of the next year, calculate the first day of the Year of the year in which the given date is
Select DATEADD (Year,1+datediff (year,0, @date), 0) as ' the first day of the next year of the Year '
--At the end of the next year, calculate the last day of the year in which the given date is located
Select DATEADD (Year,1+datediff (year,-1, @date), -1) as ' The last day of the next year of the Year '
Go