Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the day of the month of its argument as an integer between 1 and 31.
DAY( date-expression )
The date as a DATE data type.
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' );