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