Skip to main content

DAYOFWEEK

Description

The DAYOFWEEK function is used to return the weekday index value corresponding to a date or time expression, following the rule where Sunday is 1, Monday is 2, ..., and Saturday is 7.

This function behaves consistently with the dayofweek function in MySQL

Alias

  • DOW

Syntax

DAYOFWEEK(<date_or_time_expr>)

Parameters

ParameterDescription
<date_or_time_expr>A valid date expression that supports date/datetime types. For specific datetime and date formats, please refer to datetime conversion and date conversion

Return Value

Returns an integer representing the weekday index value corresponding to the date (1-7, where 1 represents Sunday and 7 represents Saturday).

Special cases:

If <date_or_time_expr> is NULL, returns NULL;

Examples

---Calculate weekday index value for date type
select dayofweek('2019-06-25');

+----------------------------------+
| dayofweek('2019-06-25 00:00:00') |
+----------------------------------+
| 3 |
+----------------------------------+

---Calculate weekday index value for datetime type
select dayofweek('2019-06-25 15:30:45');

+----------------------------------+
| dayofweek('2019-06-25 15:30:45') |
+----------------------------------+
| 3 |
+----------------------------------+
---Index for Sunday
select dayofweek('2024-02-18');
+-------------------------+
| dayofweek('2024-02-18') |
+-------------------------+
| 1 |
+-------------------------+

---Input datetime is NULL, returns NULL
select dayofweek(NULL);
+-----------------+
| dayofweek(NULL) |
+-----------------+
| NULL |
+-----------------+