Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

DAYOFWEEK

Extracts the day of the week from a date. Sunday is 1, Monday is 2, etc.

Syntax

DAYOFWEEK (dateobj)

Arguments

  • dateobj: a valid date, datetime, or parsable date string.

Return Type

Integer. If dateobj is not a valid date, returns NULL.

Examples

select dayofweek('2014-04-18');
+-------------------------+
| dayofweek('2014-04-18') |
+-------------------------+
|                       6 |
+-------------------------+