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.