MySQL YEAR() Function
❮ MySQL Functions
Definition and Usage
The YEAR() function returns the year part for a given date (a number from 1000 to 9999).
Syntax
YEAR(date)
Parameter Values
Parameter |
Description |
date |
Required. The date/datetime to extract the
year from |
Technical Details
More Examples
Example
Return the year part of a date:
SELECT YEAR("2017-06-15 09:34:21");
Try it Yourself »
Example
Return the year part of the current system date:
SELECT YEAR(CURDATE());
Try it Yourself »
❮ MySQL Functions
W3schools Pathfinder
Track your progress - it's free!