ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

DAY function [Date and time]

Function 

Returns an integer from 1 to 31 corresponding to the day of the month of a date.

Syntax 

DAY ( date-expression )

Parameters 

date-expression    The date.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

Example 

The following statement returns the value 12.

SELECT DAY( '2001-09-12' )