Was this helpful?
Returns the day of the week from the given epoch millis in UTC timezone. The value ranges from 1(Monday) to 7(Sunday).
dayOfWeek(tsInMillis)dayOfWeek(tsInMillis, timeZoneId)dow(tsInMillis)dow(tsInMillis, timeZoneId)
dayOfWeek(tsInMillis)
dayOfWeek(tsInMillis, timeZoneId)
dow(tsInMillis)
dow(tsInMillis, timeZoneId)
select dayOfWeek(1639351800000) AS dayOfWeek FROM ignoreMe
7
select dayOfWeek(1639351800000, 'CET') AS dayOfWeek FROM ignoreMe
1
select dow(1639351800000) AS dayOfWeek FROM ignoreMe
select dow(1639351800000, 'CET') AS dayOfWeek FROM ignoreMe
This section contains reference documentation for the dayOfWeek function.