DAYOFYEAR

Returns the day of the year from a date.

Analyze Syntax

func.dayofyear(<date>)

Analyze Examples

func.dayofyear('2024-06-15')

┌─────┐
 167  
└─────┘

SQL Syntax

DAYOFYEAR(<date>)

SQL Examples

SELECT DAYOFYEAR('2024-06-15');

┌─────┐
 167  
└─────┘