Progress
SQL-92
Guide and Reference
DAYOFMONTH Function
Returns the day of the month in the argument as a short integer value in the range of 1-31. The argument date_expression can be the name of a column, the result of another scalar function, or a date or timestamp literal.
SYNTAX
EXAMPLE
This example illustrates the DAYOFMONTH function:
NOTES
- The
date_expression
argument must be of type DATE.- If
date_expression
is supplied as a date literal, it can be any of the validdate_literal
formats where the day specification (DD) precedes the month specification (MM). See syntax fordate_literal
in the "Date-time Literals" section in SQL-92 Language Elements."- The result is of type SHORT.
- If the argument expression evaluates to null, the result is null.
COMPATIBILITY
ODBC Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |