DAYOFYEAR (Lakehouse v2)

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  │
└─────┘