Apache Pinot Docs
Search…
latest
Configuration Reference
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 6mo ago
Copy link