DAY_OF_WEEK
Last updated: 9/21/2026Returns the ISO day of the week from a timestamp.
Return values range from 1 to 7 :
| ISO Day of Week | Week Day |
|---|---|
| 1 | Monday |
| 2 | Tuesday |
| 3 | Wednesday |
| 4 | Thursday |
| 5 | Friday |
| 6 | Saturday |
| 7 | Sunday |
Syntax
DAY_OF_WEEK(timestamp)
Arguments
| Name | Type | Description | Default Value |
|---|---|---|---|
| timestamp | timestamp |
Returns
bigint
Examples
| timestamp | Output |
|---|---|
| timestamp "2018-03-10 08:55:12.456" | 6 |