DAYOFWEEK

    Date/Time functions

    Syntax

    DAYOFWEEK( datetime [ , firstday ] )
    

    Description

    Returns the day of the week according to ISO 8601.

    • Monday — 1.
    • Sunday — 7.

    If the additional parameter firstday is specified, this day is considered the first day of the week. Valid values:

    • "Monday", "Mon" — Monday.
    • "Tuesday". "Tue" — Tuesday.
    • "Wednesday", "Wed" — Wednesday.
    • "Thursday", "Thu" — Thursday.
    • "Friday", "Fri" — Friday.
    • "Saturday", "Sat" — Saturday.
    • "Sunday", "Sun" — Sunday.

    Argument types:

    • datetimeDate | Datetime
    • firstdayString

    Return type: Number (whole)

    Note

    Only constant values are accepted for arguments (firstday).

    Examples

    DAYOFWEEK(#1971-01-14 01:02:03#) = 4
    
    DAYOFWEEK(#1971-01-14#, "wed") = 2
    
    DAYOFWEEK(#1971-01-14#, "wednesday") = 2
    

    Data source support

    Materialized Dataset, ClickHouse 1.1, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3