Contact UsGet started

DAYOFWEEK

Written by
Improved by
Updated at November 6, 2024

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

Note

Only constant values are accepted for the 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

ClickHouse 21.8, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Yandex Documents, YDB.

Previous
DAY
Next
HOUR