Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Returns the weekday number with Monday numbered zero.
weekday(value)
| Name | Type | Required | Description |
|---|---|---|---|
| value | TIMESTAMP | Yes | Timestamp whose weekday is extracted. |
| Property | Value |
|---|---|
| Deterministic | Yes |
| Exact result | Yes |
SELECT weekday(TIMESTAMP '2024-03-15 00:00:00') AS result;
| result |
|---|
| 4 |
SELECT weekday(TIMESTAMP '2024-03-18 00:00:00') AS result;
| result |
|---|
| 0 |
SELECT weekday(TIMESTAMP '2024-03-17 00:00:00') AS result;
| result |
|---|
| 6 |