DAYOFMONTH(date) returns the day of the month for a given date. : DAYOFMONTH « Date Time Functions « MySQL Tutorial

1. MySQL Tutorial
2. Date Time Functions
3. DAYOFMONTH

mysql>
mysql> SELECT DAYOFMONTH(20000201);
+----------------------+
| DAYOFMONTH(20000201) |
+----------------------+
|                    1 |
+----------------------+
1 row in set (0.00 sec)

mysql> SELECT DAYOFMONTH('00-02-01');
+------------------------+
| DAYOFMONTH('00-02-01') |
+------------------------+
|                      1 |
+------------------------+
1 row in set (0.00 sec)

mysql>