Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Get month of a date
SELECT MONTH(CURRENT_DATE);
/*
mysql> SELECT MONTH(CURRENT_DATE);
+---------------------+
| MONTH(CURRENT_DATE) |
+---------------------+
|                  10 |
+---------------------+
1 row in set (0.00 sec)
*/