Hello
we are observing wrong result for below quer...
# generals
San Kumar
12/17/2025, 12:25 PMHello
we are observing wrong result for below query
select dateTrunc('hour', 1765295114678, 'MILLISECONDS', 'America/New_York', 'MILLISECONDS') AS original_event_time_hours_buckets2,dateTrunc('hour', 1765295114678, 'MILLISECONDS', 'Europe/Berlin', 'MILLISECONDS') AS original_event_time_hours_buckets from test limit 10
its giving us same Epoch milliseconds as UTC.
1765292400000 1765292400000
it should have different epoch milliseconds for different timezone.How ever ASIA/Kolkota timezone is giving correct result.
is it bug for timezone aware query for pinot?
m
Mayank
12/17/2025, 2:54 PM
Epoch millis is always UTC. Can you try another format when converting to different time zone?
s
San Kumar
12/17/2025, 2:59 PMCan you please guide me what format I can try
x
Xiang Fu
12/18/2025, 10:29 PM
Xiang Fu
12/18/2025, 10:30 PM
Copy code
SELECT
toDateTime(
dateTrunc('hour', 1765295114678, 'MILLISECONDS', 'America/New_York', 'MILLISECONDS'),
'yyyy-MM-dd HH:mm:ss',
'America/New_York'
) AS ny_local_hour,
toDateTime(
dateTrunc('hour', 1765295114678, 'MILLISECONDS', 'Europe/Berlin', 'MILLISECONDS'),
'yyyy-MM-dd HH:mm:ss',
'Europe/Berlin'
) AS berlin_local_hour,
toDateTime(
dateTrunc('hour', 1765295114678, 'MILLISECONDS', 'Asia/Kolkata', 'MILLISECONDS'),
'yyyy-MM-dd HH:mm:ss',
'Asia/Kolkata'
) AS kolkata_local_hour
FROM test
LIMIT 1;Xiang Fu
12/18/2025, 10:31 PM
image.png