YEAR (Transact-SQL) - SQL Server | Microsoft Docs
https://docs.microsoft.com/en-us/sql/t-sql/functions/year-transact-sql
YEAR returns the same value as DATEPART (year, date). If date only contains a time part, the return value is 1900, the base year. Examples. The following statement returns 2010. This is the number of the year. SELECT YEAR('2010-04-30T01:01:01.1234567-07:00'); The following statement returns 1900, 1, 1. The argument for date is the number 0.
DA: 34 PA: 94 MOZ Rank: 31