SQL YEAR() Function

SQL YEAR() Syntax

The below syntax is used to get year value from a given input date value using YEAR() function.

For SQL SERVER / MY SQL / MS ACCESS

SELECT YEAR('valid_date_value');

The below syntax is used to read year portion value from a given table column using YEAR() function

For MS ACCESS / SQL SERVER / MY SQL

SELECT YEAR(date_column_name1) FROM table_name;

SQL YEAR() Example - Using Expression Or Formula

The following SQL SELECT statement will extract the year value from a given input date value. We use now() function to get the input date value.

SELECT 
NOW() AS 'Current Date and Time', 
YEAR(NOW()) AS 'Year Value';

The result of above query is:

Sample Database Table - BookOrder

SQL YEAR() Example - With Table Column

The following SQL SELECT statement display the column "OrderDate" and "DeliveryDate" from the "BookOrder" table. The YEAR() function will extract the year value(a four digit number) from the column "OrderDate" and we will stored that value to a new column called "Order Year" and "Delivery Year".

SELECT 
OrderDate, YEAR(OrderDate) As 'Order Year', 
DeliveryDate, YEAR(DeliveryDate) As 'Delivery Year' 
FROM BookOrder;

The result of above query is: