Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. MONTH(date) returns the month for date, in the range 0 to 12
mysql>
mysql> SELECT MONTH('1998-02-03');
+---------------------+
| MONTH('1998-02-03') |
+---------------------+
|                   2 |
+---------------------+
1 row in set (0.00 sec)
mysql>