SQL Function Reference

Returns returns the ordinal number of the day in the month (from 1 to 31)

DAY(datetime)

SELECT DAY("2022-06-16");