DAY returns the day of the month(1-31) of a date literal.

SYNTAX:

DAY(date literal)

EXAMPLES:

DAY(D) - Returns the day of the month for the current date (date being calculated).