version 11
DAY (arithmetic_expression)
Description
The DAY function returns the day of the month for the date passed in the arithmetic_expression.
Example
This example returns the day of the month for the date "05-07-2007":
SELECT DAY('05-07-2007'); `returns 7
See Also
DAYNAME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR.