DAYOFWEEK (Lakehouse v2)
Returns the day of the week index for a date (1=Sunday, 7=Saturday).
Analyze Syntax
Section titled “Analyze Syntax”func.dayofweek(<date>)Analyze Examples
Section titled “Analyze Examples”func.dayofweek('2024-06-15')
┌───┐│ 7 │└───┘SQL Syntax
Section titled “SQL Syntax”DAYOFWEEK(<date>)SQL Examples
Section titled “SQL Examples”SELECT DAYOFWEEK('2024-06-15');
┌───┐│ 7 │└───┘