Outdated Version

You are viewing an older version of this section. View current production version.


Extracts the day of the week from a date. Monday is 0, Tuesday is 1, etc.

WEEKDAY (dateobj)


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

Return Type

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


memsql> select weekday('2014-04-18');
| weekday('2014-04-18') |
|                     4 |