I'm encountering an issue with timezone conversion in a Perspective table. The table is bound to a named query, and the result includes start_time and end_time columns in UTC. My Perspective project is configured with the timezone ID set to "America/Lima," and all other components correctly convert timestamps to this timezone.
However, this specific table seems to be offsetting timestamps by -2 instead of the expected -5 (GMT-5). Other components like journal tables, alarms, and charts are displaying the correct timezone conversion.
In the Perspective project settings, the timezone ID is correctly set to "Client TimeZone."
I'm seeking advice on how to troubleshoot and resolve this issue specifically for the Perspective table. Has anyone encountered a similar problem or can provide insights into why this might be happening?
If I understand correctly, the start_time and end_time timestamps are returned by your named query in UTC time. Your could convert it to local time directly in your named query SELECT statement like this:
SELECT [start_time] AT TIME ZONE 'UTC' AT TIME ZONE 'SA Pacific Standard Time' AS 'LocalStartTime'
FROM ...
