How to get year from date in SQL?

Question

Can anyone explain how to get year from the date in SQL?

Answer 1

We can use YEAR() function to get the year from the date in SQL. Here is the syntax to get the year from the date in SQL:

SELECT YEAR (Date) as Year;

Here is the syntax to get the year from the current system date:

SELECT YEAR (CURDATE());

I recommend registering for this SQL training course by Intellipaat to learn SQL.