Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

DAY (SQL)

A date function that returns the day of the month for a date expression.

Synopsis

DAY(date-expression)
{fn DAY(date-expression)}

Arguments

Argument Description
date-expression An expression that is the name of a column, the result of another scalar function, or a date or timestamp literal.

Description

Note:

The DAY function is an alias for the DAYOFMONTH function. DAY is provided for TSQL compatibility. Refer to DAYOFMONTH for further details.

See Also

Feedback