phpAsks.com

EXTRACT()

EXTRACT(type FROM date)

La función EXTRACT() usa los mismos tipos de especificadores de intervalos que DATE_ADD() o DATE_SUB(), pero extrae partes de la fecha en lugar de realizar aritmética de fechas.

mysql>mysql> SELECT EXTRACT(YEAR FROM "1999-07-02");
+---------------------------------+
| EXTRACT(YEAR FROM "1999-07-02") |
+---------------------------------+
|                            1999 |
+---------------------------------+
1 row in set (0.00 sec)

mysql> SELECT EXTRACT(YEAR_MONTH FROM "1999-07-02 01:02:03");
+------------------------------------------------+
| EXTRACT(YEAR_MONTH FROM "1999-07-02 01:02:03") |
+------------------------------------------------+
|                                         199907 |
+------------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT EXTRACT(DAY_MINUTE FROM "1999-07-02 01:02:03");
+------------------------------------------------+
| EXTRACT(DAY_MINUTE FROM "1999-07-02 01:02:03") |
+------------------------------------------------+
|                                          20102 |
+------------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT EXTRACT(MICROSECOND FROM "2003-01-02 10:30:00.00123");
        -> 123

MySQL

Functions

ADDDATE ADDTIME CONVERT_TZ CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATE DATEDIFF DATE_ADD DATE_FORMAT DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT FROM_DAYS FROM_UNIXTIME GET_FORMAT HOUR LAST_DAY LOCALTIME LOCALTIMESTAMP MAKEDATE MAKETIME MICROSECOND MINUTE MONTH MONTHNAME NOW PERIOD_ADD PERIOD_DIFF QUARTER SECOND SEC_TO_TIME STR_TO_DATE SUBDATE SUBTIME SYSDATE TIME TIMEDIFF TIMESTAMP TIMESTAMPADD TIMESTAMPDIFF TIME_FORMAT TIME_TO_SEC TO_DAYS UNIX_TIMESTAMP UTC_DATE UTC_TIME UTC_TIMESTAMP WEEK WEEKDAY WEEKOFYEAR YEAR YEARWEEK