What is DAYOFMONTH() in SQL?

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.

Figure 1: Visual representation of DAYOFMONTH() function

Syntax

```sql DAYOFMONTH(date) ```

Parameter

The `DAYOFMONTH()` function takes the date as a parameter. > The date must be in the format YYYY-MM-DD, or else this function returns `NULL`.

Return value

The `DAYOFMONTH()` function returns the day of the month from a date sent as a parameter. > It returns `NULL` if the date is invalid.

Code

-- current date
SELECT DAYOFMONTH(NOW());
-- invalid month
SELECT DAYOFMONTH('2021-13-12');
-- valid month/day
SELECT DAYOFMONTH('2021-05-03');
-- invalid day
SELECT DAYOFMONTH('2021-2-30');

Free Resources