You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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

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