Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. DAYOFMONTH(date) returns the day of the month for a given date
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>