DAYOFWEEK

​

Syntax

​

Scalar

dayofweek(value)

​

Arguments

​

Returns

• Type: INTEGER
• Possible values: Sunday=1 through Saturday=7.
• NULL behavior: NULL input returns NULL.

​

Properties

​

Usage notes

• Date and time components are returned as INTEGER.
• Deterministic: The same inputs and settings produce the same result.

​

Examples

​

Typical behavior

SELECT dayofweek(DATE '2024-03-15') AS "value";

​

Sunday and Monday numbering

SELECT dayofweek(DATE '2024-03-17') AS sunday, dayofweek(DATE '2024-03-18') AS monday;

​

Related functions

• date_part