MONTH('2005-00-00'); : MONTH « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. MONTH
mysql>
mysql> SELECT MONTH('2005-00-00');
+---------------------+
| MONTH('2005-00-00') |
+---------------------+
|                   0 |
+---------------------+
1 row in set (0.00 sec)








14.30.MONTH
14.30.1.MONTH('2005-00-00');
14.30.2.MONTH(date) returns the month for date, in the range 0 to 12.
14.30.3.Get Month name of the employee's start date
14.30.4.Use month function with data in a table
14.30.5.Use month function in where clause
14.30.6.Combine Month function and Date_add function