How to Use the YEAR() Function in SQL Server: A Complete Guide

Syntax:

<span class="pln">
</span><span class="typ">Year</span><span class="pun">()</span><span class="pln">
</span>

Returns the 'Year number' of the given date.

Code:

<span class="pln">
</span><span class="typ">Select</span><span class="pln"> </span><span class="typ">Year</span><span class="pun">(</span><span class="pln">GETDATE</span><span class="pun">())</span><span class="pln"> 
</span>

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

<span class="pln">
</span><span class="typ">Select</span><span class="pln"> </span><span class="typ">Year</span><span class="pun">(</span><span class="str">'01/31/2019'</span><span class="pun">)</span><span class="pln">
</span>

Output:

The above code will produce the following result-

<span class="pln">
</span><span class="lit">2019</span><span class="pln">
</span>