DAY_OF_YEAR
Last updated: 9/21/2026Returns the day of the year from the timestamp.
Values range from 1 to 366.
Syntax
DAY_OF_YEAR(timestamp)
Arguments
| Name | Type | Description | Default Value |
|---|---|---|---|
| timestamp | timestamp |
Returns
bigint
Examples
| timestamp | Output |
|---|---|
| timestamp "2018-03-10 08:55:12.456" | 69 |