MySQL Date and Time Exercises: Extract the year from the current date

MySQL Date Time: Exercise-9 with Solution

Write a query to extract the year from the current date.

Code:

SELECT EXTRACT(YEAR FROM  NOW());

Sample Output:

EXTRACT(YEAR FROM NOW())
2017

MySQL Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous:Write a query to get the current date in Thursday September 2014 format.
Next:Write a query to get the DATE value from a given day (number in N).