MySQL YEAR() Function
THE WORLD'S LARGEST WEB DEVELOPER SITE
HTML CSS JAVASCRIPT SQL PHP BOOTSTRAP HOW TO JQUERY W3.CSS ANGULAR XML MORE FORUM EXAMPLES REFERENCES

MySQL YEAR() Function

❮ MySQL Functions

Example

Return the year portion of a date:

SELECT YEAR("2017-06-15");
Try it Yourself »

Definition and Usage

The YEAR() function returns the year portion of a date value (a number from 1000 to 9999).

Syntax

YEAR(date)

Parameter Values

Parameter Description
date Required.  The date or datetime value from which to extract the year

Technical Details

Works in: MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23

More Examples

Example

Return the year portion of a date:

SELECT YEAR("2017-06-15 09:34:21");
Try it Yourself »

Example

Return the year portion of the current system date:

SELECT YEAR(CURDATE());
Try it Yourself »

❮ MySQL Functions