The DAYOFMONTH()
function returns what day of the month it is from a date sent as a parameter.
Figure 1 shows a visual representation of the DAYOFMONTH()
function.
-- current dateSELECT DAYOFMONTH(NOW());-- invalid monthSELECT DAYOFMONTH('2021-13-12');-- valid month/daySELECT DAYOFMONTH('2021-05-03');-- invalid daySELECT DAYOFMONTH('2021-2-30');