DAY function [Date and time]

Function

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

Syntax

DAY ( date-expression )

Parameters

date-expression The date.

Example

The following statement returns the value 12:

SELECT DAY( '2001-09-12' ) FROM iq_dummy

Standards and compatibility

SQL92 Vendor extension.

Sybase Not supported by Adaptive Server Enterprise.