Skip to main content
Version: 3.2

dayofmonth

Description​

Obtains the day part in a date and returns a value that ranges from 1 to 31.

The date parameter must be of the DATE or DATETIME type.

Syntax​

INT DAYOFMONTH(DATETIME date)

Examples​

MySQL > select dayofmonth('1987-01-31');
+-----------------------------------+
| dayofmonth('1987-01-31 00:00:00') |
+-----------------------------------+
|                                31 |
+-----------------------------------+

keyword​

DAYOFMONTH