DAYOFMONTH
The function DAYOFMONTH returns an integer in the range of 1 to 31. This integer represent the count of days since beginning of the month.
| SQL Syntax: |
DAYOFMONTH( date ) | |
| Date: |
Any date expression. | |
| Escape Syntax: |
{fn DAYOFMONTH( date )} | |
| Return Type: |
INT | |
Examples:
SELECT DAYOFMONTH({d '2006-01-01'}), {fn dayofmonth({d '2004-12-31'})}Returns: 1, 31
see also:
SQL Date Time Functions
DAYOFWEEK
DAYOFYEAR