DAY, DAYOFMONTH, DAY_OF_MONTH

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

Syntax

DAY(date_expression)

Syntax

DAYOFMONTH(date_expression)

Syntax

DAY_OF_MONTH(date_expression)