# Time Zone - Perspective Table

**URL:** <https://forum.inductiveautomation.com/t/time-zone-perspective-table/82053>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [November 17, 2023, 3:32pm UTC](https://forum.inductiveautomation.com/t/time-zone-perspective-table/82053 "2023-11-17T15:32:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ERICK\_CHAPARRO](https://avatars.discourse-cdn.com/v4/letter/e/c0e974/32.png) [@ERICK\_CHAPARRO](https://forum.inductiveautomation.com/u/ERICK_CHAPARRO)\
**Post date:** [November 17, 2023, 3:32pm UTC](https://forum.inductiveautomation.com/t/time-zone-perspective-table/82053/1 "2023-11-17T15:32:35Z")

</div>

Hello Ignition Community,

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?

 ![TablePerspective](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/1/a1789737023551390098acb719bcfd9fddbbfa77.png)

---

<div class="post-metadata">

**Author:** ![Oscar\_Esquivel](https://avatars.discourse-cdn.com/v4/letter/o/d9b06d/32.png) [@Oscar\_Esquivel](https://forum.inductiveautomation.com/u/Oscar_Esquivel)\
**Post date:** [June 28, 2024, 9:36pm UTC](https://forum.inductiveautomation.com/t/time-zone-perspective-table/82053/2 "2024-06-28T21:36:30Z")

</div>

> [@ERICK\_CHAPARRO](#):
>
> Hello Ignition Community,
> 
> 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?

I have the same problem, but I still can't find the solution ☹

---

<div class="post-metadata">

**Author:** ![benp](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/benp/32/34073_2.png) [@benp](https://forum.inductiveautomation.com/u/benp)\
**Post date:** [July 2, 2024, 12:34am UTC](https://forum.inductiveautomation.com/t/time-zone-perspective-table/82053/3 "2024-07-02T00:34:31Z")

</div>

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 ...

You might find this sql post helpful : [sql server - Using AT TIME ZONE to get current time in specified time zone - Stack Overflow](https://stackoverflow.com/questions/36393742/using-at-time-zone-to-get-current-time-in-specified-time-zone)

Microsoft doc:

> **[AT TIME ZONE (Transact-SQL) - SQL Server](https://learn.microsoft.com/en-us/sql/t-sql/queries/at-time-zone-transact-sql?view=sql-server-ver16&redirectedfrom=MSDN)**
>
> AT TIME ZONE Converts an input date to the corresponding datetimeoffset value in the target time zone.

---

<div class="post-metadata">

**Author:** ![Torsten\_Giesbrecht1](https://avatars.discourse-cdn.com/v4/letter/t/f17d59/32.png) [@Torsten\_Giesbrecht1](https://forum.inductiveautomation.com/u/Torsten_Giesbrecht1)\
**Post date:** [August 25, 2025, 7:55pm UTC](https://forum.inductiveautomation.com/t/time-zone-perspective-table/82053/4 "2025-08-25T19:55:19Z")

</div>

Did you ever find a solution to this? I’m having this problem as well.