ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns an integer from 1 to 31 corresponding to the day of the month of a date.
DAY ( date-expression )
date-expression The date.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported by Adaptive Server Enterprise.
The following statement returns the value 12.
SELECT DAY( '2001-09-12' )