Tag: mysql year from timestamp

MySQL YEAR Function

Example

Return the year part of a date:

SELECT YEAR("2017-06-15");

Definition and Usage

The YEAR() function returns the year part for a given date (a number from 1000 to 9999).

Syntax

YEAR(date)

Continue reading MySQL YEAR Function