WEEKDAY (Lakehouse v2)
Returns the weekday index for a date (0=Monday, 6=Sunday).
Analyze Syntax
Section titled “Analyze Syntax”func.weekday(<date>)Analyze Examples
Section titled “Analyze Examples”func.weekday('2024-06-15')
┌───┐│ 5 │└───┘SQL Syntax
Section titled “SQL Syntax”WEEKDAY(<date>)SQL Examples
Section titled “SQL Examples”SELECT WEEKDAY('2024-06-15');
┌───┐│ 5 │└───┘