SQL Function Reference

DAYOFMONTH

Returns the day of the month (1-31) for a given date.

MySQL

DAYOFMONTH(date)

date

The date or datetime value.

Examples

MySQL

SELECT DAYOFMONTH(date)
FROM Payments;

MySQL

SELECT member_name,
	DAYOFMONTH(birthday)
FROM FamilyMembers;