Returns an integer from 1 to 31.

Syntax

DAY( date-expression )

Parameters

Returns

SMALLINT

Remarks

The integers 1 to 31 correspond to the day of the month in a date.

Standards and compatibility

Example

The following statement returns the value 12.

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