EXTRACT(unit FROM date)

EXTRACT(unit FROM date)

Syntax

MYSQL Copy

SELECT EXTRACT(YEAR FROM '2019-07-02');
2019
SELECT EXTRACT(YEAR_MONTH FROM '2019-07-02 01:02:03');
201907
SELECT EXTRACT(DAY_MINUTE FROM '2019-07-02 01:02:03');
20102
SELECT EXTRACT(MICROSECOND
               FROM '2003-01-02 10:30:00.000123');
123

Examples

Example

The EXTRACT() function uses the same kinds of unit specifiers as DATE_ADD() or DATE_SUB(), but extracts parts from the date rather than performing date arithmetic. For information on the unit argument, see Temporal Intervals. Returns NULL if date is NULL.

MYSQL Copy

SELECT EXTRACT(YEAR FROM '2019-07-02');
2019
SELECT EXTRACT(YEAR_MONTH FROM '2019-07-02 01:02:03');
201907
SELECT EXTRACT(DAY_MINUTE FROM '2019-07-02 01:02:03');
20102
SELECT EXTRACT(MICROSECOND
               FROM '2003-01-02 10:30:00.000123');
123