MySQL EXTRACT() 函数

从日期中提取月份：

SELECT EXTRACT(MONTH FROM "2017-06-15");

定义和用法

EXTRACT() 函数从给定日期中提取一部分。

EXTRACT( part FROM date)

Parameter	Description
part	Required. The part to extract. Can be one of the following: MICROSECOND SECOND MINUTE HOUR DAY WEEK MONTH QUARTER YEAR SECOND_MICROSECOND MINUTE_MICROSECOND MINUTE_SECOND HOUR_MICROSECOND HOUR_SECOND HOUR_MINUTE DAY_MICROSECOND DAY_SECOND DAY_MINUTE DAY_HOUR YEAR_MONTH
date	Required. The date to extract a part from

工作于：	从 MySQL 4.0 开始