DAY( date-expression )

SMALLINT

The DAY function returns an integer between 1 and 31, corresponding to the day of the month in the argument.

The following statement returns the value 12:

SELECT DAY( '2001-09-12' );