Product Solutions Support
Try MemSQL

WEEKDAY

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

WEEKDAY (dateobj)

Arguments

Return Type

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

Examples

memsql> select weekday('2014-04-18');
+-----------------------+
| weekday('2014-04-18') |
+-----------------------+
|                     4 |
+-----------------------+
Was this article useful?