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.

# 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');

What is DAYOFMONTH() in SQL?

Syntax

Parameter

Return value

Code