Apache Pinot Docs
Search…
latest
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

1
select dayOfWeek(1639351800000) AS dayOfWeek
2
FROM ignoreMe
Copied!
dayOfWeek
7
1
select dayOfWeek(1639351800000, 'CET') AS dayOfWeek
2
FROM ignoreMe
Copied!
dayOfWeek
1
1
select dow(1639351800000) AS dayOfWeek
2
FROM ignoreMe
Copied!
dayOfWeek
7
1
select dow(1639351800000, 'CET') AS dayOfWeek
2
FROM ignoreMe
Copied!
dayOfWeek
1
Last modified 1mo ago
Copy link