YEAR() Function in SQL Server

Rumman Ansari   Software Engineer   2023-03-25   5488 Share
☰ Table of Contents

Table of Content:


Syntax:


Year()

Returns the 'Year number' of the given date.

Code:


Select Year(GETDATE()) 

Returns the year number, based on the current system date.


Select Year('01/31/2019')

Output:

The above code will produce the following result-


2019