MAKEDATE
Creates a date from a year and day-of-year value.
Analyze Syntax
func.makedate(<year>, <dayofyear>)
Analyze Examples
func.makedate(2024, 100)
┌──────────────┐
│ '2024-04-09' │
└──────────────┘
SQL Syntax
MAKEDATE(<year>, <dayofyear>)
SQL Examples
SELECT MAKEDATE(2024, 100);
┌────────────┐
│ 2024-04-09 │
└────────────┘