# WEEKDAY

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

## Syntax

```
WEEKDAY (dateobj)

```

## Arguments

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

## Return Type

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

## Examples

```sql
SELECT WEEKDAY('2014-04-18');

```

```output

+-----------------------+
| WEEKDAY('2014-04-18') |
+-----------------------+
|                     4 |
+-----------------------+

```

**Related Topics**

* [WEEK](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/week.md)
* [MONTH](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/month.md)
* [YEAR](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/year.md)

***

Modified at: May 31, 2023

Source: [/cloud/reference/sql-reference/date-and-time-functions/weekday/](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/weekday/)

(An index of the documentation is available at /llms.txt)