DAY

Returns just the day (1..31) of the month for the specified date.

Syntax

DAY(date)

Arguments

date Date value to extract the day.  Use the format (year, month, day)

Example

DAY(DATE(1998,10,28)) returns 28.