Apache Pinot Docs
latest
Search
⌃K

dayOfWeek

This section contains reference documentation for the dayOfWeek function.
Returns the day of the week from the given epoch millis in UTC timezone. The value ranges from 1(Monday) to 7(Sunday).

Signature

dayOfWeek(tsInMillis)
dayOfWeek(tsInMillis, timeZoneId)
dow(tsInMillis)
dow(tsInMillis, timeZoneId)

Usage Examples

select dayOfWeek(1639351800000) AS dayOfWeek
FROM ignoreMe
dayOfWeek
7
select dayOfWeek(1639351800000, 'CET') AS dayOfWeek
FROM ignoreMe
dayOfWeek
1
select dow(1639351800000) AS dayOfWeek
FROM ignoreMe
dayOfWeek
7
select dow(1639351800000, 'CET') AS dayOfWeek
FROM ignoreMe
dayOfWeek
1
Last modified 1yr ago