MySQL DAYOFMONTH() Function

The dayofmonth() is a MySQL date/time function. It is used to get the day from the given date.

Syntax

Parameter:

date_name: date for getting day.

Returns

This function returns the day portion of a date value.

Example 1

Output:

Example 2

Output: