WEEKDAY
Learn how to use the WEEKDAY date/time function in PlaidCloud Lakehouse. Returns the weekday index for a date (0=Monday, 6=Sunday) - with syntax and examples.
Returns the weekday index for a date (0=Monday, 6=Sunday).
Analyze Syntax
func.weekday(<date>)
Analyze Examples
func.weekday('2024-06-15')
┌───┐
│ 5 │
└───┘
SQL Syntax
WEEKDAY(<date>)
SQL Examples
SELECT WEEKDAY('2024-06-15');
┌───┐
│ 5 │
└───┘