The DAYOFMONTH() function returns the day of the month of "Date" in the range 1 to 31.
The "Date" argument must be of type DATE or DATETIME.
For invalid dates like 0000-00-00 that have a 00 day part, the function returns 0.
If the value for "Date" is invalid or NULL, the DAYOFMONTH() function returns NULL. |