Skip to main content

TO_DAY_OF_YEAR

Converts a date or date with time (timestamp/datetime) to a UInt16 number containing the number of the day of the year (1-366).

Syntax​

TO_DAY_OF_YEAR(<expr>)

Arguments​

ArgumentsDescription
<expr>date/timestamp

Return Type​

SMALLINT

Examples​

SELECT to_day_of_year(to_date(18869));
+--------------------------------+
| to_day_of_year(to_date(18869)) |
+--------------------------------+
|                            242 |
+--------------------------------+

SELECT to_day_of_year(now());
+-----------------------+
| to_day_of_year(now()) |
+-----------------------+
|                    88 |
+-----------------------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today