Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

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>