DAYOFYEAR
Learn how to use the DAYOFYEAR date/time function in PlaidCloud Lakehouse. Returns the day of the year from a date - see syntax, examples, and output.
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 │
└─────┘