DAYOFMONTH

PostgreSQL equivalent:

Returns the day of the month of a date.

MySQL 8.4

DAYOFMONTH(date)

Return value

An integer from 1 to 31; 0 for a date with a zero day, for example 2022-00-00; NULL if the value is not recognized as a date

MySQL 8.4

SELECT DAYOFMONTH('2022-06-16');

DAYOFMONTH('2022-06-16')
16

MySQL 8.4

SELECT member_name,
	DAYOFMONTH(birthday) AS birth_day
FROM FamilyMembers;

The function is a synonym for DAY.