EXTRACT

Extracts the given part from a date or time.

MySQL 8.4

EXTRACT(unit FROM date)

unit: Part of the date or time to extract
Keyword
MICROSECONDSECONDMINUTEHOURDAYWEEKMONTHQUARTERYEARSECOND_MICROSECONDMINUTE_MICROSECONDMINUTE_SECONDHOUR_MICROSECONDHOUR_SECONDHOUR_MINUTEDAY_MICROSECONDDAY_SECONDDAY_MINUTEDAY_HOURYEAR_MONTH
date: Date, time or datetime
DATETIME

Return value

An integer; parts of a compound unit are joined: YEAR_MONTH for 2024-03-08 gives 202403

MySQL 8.4

SELECT EXTRACT(
		MONTH
		FROM '2024-03-08 14:30:00'
	);

EXTRACT(MONTH FROM '2024-03-08 14:30:00')
3

MySQL 8.4

SELECT member_name,
	EXTRACT(
		YEAR
		FROM birthday
	) AS birth_year
FROM FamilyMembers;

MySQL 8.4

SELECT EXTRACT(
		HOUR_MINUTE
		FROM '2024-03-08 14:30:00'
	) AS hhmm;

hhmm
1430

EXTRACT is standard SQL syntax: unlike YEAR, MONTH and other separate functions, it also exists in PostgreSQL, but without compound units.