Apache Pinot Docs
latest
Ask or search…
K
Comment on page

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

select day(1639351800000) AS day
FROM ignoreMe
day
12
select day(1639351800000, 'CET') AS day
FROM ignoreMe
day
13
select dayOfMonth(1639351800000) AS day
FROM ignoreMe
day
12
select dayOfMonth(1639351800000, 'CET') AS day
FROM ignoreMe
day
13
Last modified 1yr ago