DAYOFWEEK

Returns the day of the week index for a date (1=Sunday, 7=Saturday).

Analyze Syntax

func.dayofweek(<date>)

Analyze Examples

func.dayofweek('2024-06-15')

┌───┐
 7  
└───┘

SQL Syntax

DAYOFWEEK(<date>)

SQL Examples

SELECT DAYOFWEEK('2024-06-15');

┌───┐
 7  
└───┘