DAYOFWEEK

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:

• datetime — Date | Datetime
• firstday — String

Return type: Integer

Examples

DAYOFWEEK(#1971-01-14 01:02:03#) = 4

DAYOFWEEK(#1971-01-14#, "wed") = 2

DAYOFWEEK(#1971-01-14#, "wednesday") = 2

Data source support

ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.