Returns an integer from 1 to 31.
DAY( date-expression )
date-expression The date.
The integers 1 to 31 correspond to the day of the month in a date.
SQL/2003 Vendor extension.
The following statement returns the value 12.
SELECT DAY( '2001-09-12' );