Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. SELECT EXTRACT(YEAR_MONTH FROM 1999-07-02 01
mysql>
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>