https://pinot.apache.org/ logo
#general
Title
# general
c

Carl

04/22/2022, 2:44 PM
Hi team, we have a datetimefield column storing epoc milliseconds from local time zone, is there a transformation in Pinot supporting convert it into UTC timestamp with Pinot query?
e

erik bergsten

04/22/2022, 2:48 PM
this function: https://docs.pinot.apache.org/configuration-reference/functions/datetimeconvert can convert epochmillis to datetime strings
thankyou 1
c

Carl

04/22/2022, 3:04 PM
I tried to add ‘1MILLISECONDSEPOCH tz(US/Pacific)’ as the input format. But got query error.
e

erik bergsten

04/22/2022, 3:13 PM
I dont think epochmilliseconds are timezoned
c

Carl

04/22/2022, 3:20 PM
So we have to store epoch milliseconds in UTC in order to convert to other TZ, not the other way around, right?
m

Mayank

04/22/2022, 9:12 PM
DateTimeConvert
can do all the time zone conversions
c

Carl

04/25/2022, 4:38 PM
Thanks, but it looks like using this convention I can't put source tz as UTC if the timestamp was stored as epoch milliseconds?
m

Mayank

04/25/2022, 7:41 PM
epoch is always UTC. So you’d store it as epoch, and can then query on local tz