Apache Pinot Docs
Search…
latest
Configuration Reference
day
This section contains reference documentation for the day function.
Returns the day of the month from the given epoch millis in UTC or specified timezone. The value ranges from 1 to 31.

Signature

day(tsInMillis)
day(tsInMillis, timeZoneId)
dayOfMonth(tsInMillis)
dayOfMonth(tsInMillis, timeZoneId)

Usage Examples

1
select day(1639351800000) AS day
2
FROM ignoreMe
Copied!
day
12
1
select day(1639351800000, 'CET') AS day
2
FROM ignoreMe
Copied!
day
13
1
select dayOfMonth(1639351800000) AS day
2
FROM ignoreMe
Copied!
day
12
1
select dayOfMonth(1639351800000, 'CET') AS day
2
FROM ignoreMe
Copied!
day
13
Last modified 6mo ago
Copy link