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?

this function: https://docs.pinot.apache.org/configuration-reference/functions/datetimeconvert can convert epochmillis to datetime strings

I tried to add ‘1MILLISECONDSEPOCH tz(US/Pacific)’ as the input format. But got query error.

I dont think epochmilliseconds are timezoned

So we have to store epoch milliseconds in UTC in order to convert to other TZ, not the other way around, right?

DateTimeConvert

can do all the time zone conversions

Thanks, but it looks like using this convention I can't put source tz as UTC if the timestamp was stored as epoch milliseconds?

epoch is always UTC. So you’d store it as epoch, and can then query on local tz