EXTRACT(unit FROM date)

EKSTRAK(satuan DARI tanggal)

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

Contoh

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