DAY, DAYOFMONTH, DAY_OF_MONTH

Use DAY, DAYOFMONTH, or DAY_OF_MONTH to return the day from a date expression.

Syntax

DAY(date_expression)

DAYOFMONTH(date_expression)

DAY_OF_MONTH(date_expression)