DAY (SQL)
A date function that returns the day of the month for a date expression.
Synopsis
DAY(date-expression)
{fn DAY(date-expression)}
Description
DAY returns the day of the month for a given date expression.
The DAY function is an alias for the DAYOFMONTH function. DAY is provided for TSQL compatibility. Refer to DAYOFMONTH for further details.
Arguments
date-expression
An expression that is the name of a column, the result of another scalar function, or a date or timestamp literal.
See Also
Purpose of this instance: Draft documentation
DocReleaseID: SupplyChain2025.1
Content loaded from:
/staging/learning/iris-doc/2025.1.x/doc/supply-chain/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/cache/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/ensemble/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/iris/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/security/en-us/src/
Excluded items: PAGE_bi, PAGE_deployment, PAGE_interoperability, PAGE_release