EXTRACT
Extracts the given part from a date or time.
MySQL 8.1
EXTRACT(unit FROM date)Parameters
- unitkeyword
- Part of the date or time to extract
- Values:MICROSECONDSECONDMINUTEHOURDAYWEEKMONTHQUARTERYEARSECOND_MICROSECONDMINUTE_MICROSECONDMINUTE_SECONDHOUR_MICROSECONDHOUR_SECONDHOUR_MINUTEDAY_MICROSECONDDAY_SECONDDAY_MINUTEDAY_HOURYEAR_MONTH
- dateDATETIME
- Date, time or datetime
Return value
An integer; parts of a compound unit are joined: YEAR_MONTH for 2024-03-08 gives 202403
Examples
Month from a date and time
MySQL 8.1
SELECT EXTRACT(
MONTH
FROM '2024-03-08 14:30:00'
);Birth year from a table
MySQL 8.1
SELECT member_name,
EXTRACT(
YEAR
FROM birthday
) AS birth_year
FROM FamilyMembers;Compound unit HOUR_MINUTE
MySQL 8.1
SELECT EXTRACT(
HOUR_MINUTE
FROM '2024-03-08 14:30:00'
) AS hhmm;Details
EXTRACT is standard SQL syntax: unlike YEAR, MONTH and other separate functions, it also exists in PostgreSQL, but without compound units.