EXTRACT()¶

Function Description¶

The EXTRACT() function extracts part of the content from a date. Returns NULL if the date is NULL.

Function Syntax¶

> EXTRACT(unit FROM date)

Parameter definition¶

Parameters	Description
date	Required parameters. The date parameter is a legal date expression.
unit	Required parameters. The unit parameter can be the following values: MICROSECOND SECOND MINUTE HOUR DAY WEEK MONTH QUA TER YEAR SECOND_MICROSECOND MINUTE_MICROSECOND MINUTE_MICROSECOND MINUTE_SECOND HOUR_MICROSECOND HOUR_MICROSECOND HOUR_SECOND HOUR_SECOND HOUR_SECOND HOUR_MINUTE DAY_MICROSECOND DAY_MICROSECOND DAY_MICROSECOND DAY_MICROSECOND DAY_MICROSECOND YEAR_MONTH

Example¶

create table t2(orderid int, productname varchar(20), orderdate datetime);
insert into t2 values ​​('1','Jarl','2008-11-11 13:23:44.657');

mysql> SELECT EXTRACT(YEAR FROM OrderDate) AS OrderYear, EXTRACT(MONTH FROM OrderDate) AS OrderMonth FROM t2 WHERE OrderId=1;
+------------------------------+
| orderyear | ordermonth |
+------------------------------+
| 2008 | 11 |
+------------------------------+
1 row in set (0.01 sec)

limit¶

Currently, the date format only supports the data formats of yyyy-mm-dd and yyyymmdd.