DAY_OF_YEAR
Description
Returns the day number within the year for a given date, ranging from 1 to 365 or 366.
Syntax
DAY_OF_YEAR(date) -> Integer
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| date | Date | Yes | The date to evaluate. |
Examples
DAY_OF_YEAR(DATE(2024, 1, 1))
-- Returns 1.DAY_OF_YEAR(DATE(2024, 12, 31))
-- Returns 366.