# Perspective powerchart timezone with tag history

**URL:** <https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [December 23, 2024, 10:10am UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156 "2024-12-23T10:10:30Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\
**Post date:** [December 23, 2024, 10:10am UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/1 "2024-12-23T10:10:30Z")

</div>

Hi All

I have read many forum posts on this topic but I am still struggling.

I have an AWS ignition server running Perspective. Historical data is being sent to a separate mySQL server. I would like all client sessions to use the same time zone as the ignition server (UTC). Currently, powercharts showing historical data have the time axis corrected for my geographical location. Since I am developing the system in New Zealand, this results a large time difference.

Designer time zone

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/c/9c532c505cd8ff0ff9d4a48fbb59456733547930.png)

Perspective time zone

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/6/7693313130ffc458f6e80a28872536b9db2b68dc.png)

The SQL timestamps are in UTC. I have checked this by reading the data directly (not with ignition). Please can someone explain how I can force the time zone in the browser sessions so that the data is not corrected?

Thanks.

---

<div class="post-metadata">

**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\
**Post date:** [December 23, 2024, 8:19pm UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/2 "2024-12-23T20:19:31Z")

</div>

I've added a readout of the locale and time zone to my dashboard. Both are displaying as expected based on the project properties. However, the historical data appears to be returned with the timestamp corrected to my local time. How do I stop this from being converted?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/4/94a87527c772e0358c7c2b06befe41ec394dad85.png)

The issue is also displayed when using the reporting module since this also contains an SQL query.

---

<div class="post-metadata">

**Author:** ![Chris\_Bingham](https://avatars.discourse-cdn.com/v4/letter/c/e5b9ba/32.png) [@Chris\_Bingham](https://forum.inductiveautomation.com/u/Chris_Bingham)\
**Post date:** [December 23, 2024, 10:02pm UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/3 "2024-12-23T22:02:20Z")

</div>

I believe most of the Perspective Components use the `session.props.timeZoneId` & `session.props.locale` property for converting time to client locale. Can we assume those are the properties you are displaying in your screenshot?

The below doc has some good insight as to the ~~nuisances~~ nuances of timestamps in Perspective:

> **[Time Zones in Perspective](https://support.inductiveautomation.com/hc/en-us/articles/17189847446797-Time-Zones-in-Perspective)**
>
> Introduction
> This document provides guidance on how to support multiple time zones in Ignition 8.1.3 when using Perspective. A Perspective session can run with multiple different time zones simulta...

For additional testing:

> The current time zone can be added to the display by adjusting the timeAxis \> tick \> label \> format property

and, perhaps related:

> The Date Time Input will use the browser’s time zone as the offset for the actual date and time value selected. If a different time zone is needed, then a script similar to the Time Zone Script Transform Example can be used to create an adjusted value property.

---

<div class="post-metadata">

**Author:** ![aspatchek2013](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aspatchek2013/32/85339_2.png) [@aspatchek2013](https://forum.inductiveautomation.com/u/aspatchek2013)\
**Post date:** [December 23, 2024, 10:05pm UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/4 "2024-12-23T22:05:56Z")

</div>

Are you positive that the gateway is actually set to UTC?

What happens if you change the Project Timezone to UTC instead of Gateway Timezone?

---

<div class="post-metadata">

**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\
**Post date:** [December 23, 2024, 10:16pm UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/5 "2024-12-23T22:16:39Z")

</div>

Hi and thanks for the reply.

Yes, I am displaying the session properties. The "nuisance" of handling time zones. I agree!

I will have another read of that page and add your suggestions.

Thanks again and happy holidays.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 23, 2024, 10:48pm UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/6 "2024-12-23T22:48:03Z")

</div>

John, please edit your post to not include your contact information. (Probably not good to display like that, but also [against this forum's rules](https://forum.inductiveautomation.com/faq).)

If you cannot get your mail system to omit such fragments, don't use email replies to post here at all.

---

<div class="post-metadata">

**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\
**Post date:** [December 24, 2024, 12:12am UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/7 "2024-12-24T00:12:23Z")

</div>

Apologies - I replied via email and my signature was added. Now deleted.

---

<div class="post-metadata">

**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\
**Post date:** [December 24, 2024, 12:19am UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/8 "2024-12-24T00:19:54Z")

</div>

From the gateway. Hovering over this shows "Etc/UTC"  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/d/1dfbbb7ba9da7531393902a0f49de0603771c7d6.png)

From google

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/d/5d2ce8424321a0ee07f6b8be5edb070fb869b112.png)

---

<div class="post-metadata">

**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\
**Post date:** [December 24, 2024, 12:45am UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/9 "2024-12-24T00:45:33Z")

</div>

No change when modifying to use UTC instead of gateway timezone.

---

<div class="post-metadata">

**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\
**Post date:** [December 24, 2024, 1:57am UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/10 "2024-12-24T01:57:54Z")

</div>

Update: The historian seems to be now working as expected. I'm not clear on what fixed the issue. See the 12 hour "gap" in the data below.

I did change the project time zone from "gateway" to "UTC" and then back again.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/1/d104a1842a69c263e9d27fcd4147926d0b4fa864.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 24, 2024, 2:21pm UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/11 "2024-12-24T14:21:25Z")

</div>

Was there a gateway restart mixed in there? (Ignition doesn't notice changes to the gateway OS's timezone until restart.)

---

<div class="post-metadata">

**Author:** ![Chris\_Bingham](https://avatars.discourse-cdn.com/v4/letter/c/e5b9ba/32.png) [@Chris\_Bingham](https://forum.inductiveautomation.com/u/Chris_Bingham)\
**Post date:** [December 24, 2024, 2:24pm UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/12 "2024-12-24T14:24:13Z")

</div>

A session restart might also be required between updates for many of these settings.

---

<div class="post-metadata">

**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\
**Post date:** [January 14, 2025, 7:50am UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/13 "2025-01-14T07:50:49Z")

</div>

Sorry for the slow reply. The gateway was not restarted. Ignition is running on AWS EC (Linux OS?) I have made no changes to the OS.

I had closed the Perspective session (web browser) and this did not help.

For now, the issue is resolved but I don't understand how.

Thanks

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 14, 2025, 1:05pm UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/14 "2025-01-14T13:05:27Z")

</div>

> [@eichler-eng](#):
>
> The gateway was not restarted.

> [@pturmel](#):
>
> Ignition doesn't notice changes to the gateway OS's timezone until restart.

I guess it got restarted by AWS.

---

<div class="post-metadata">

**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\
**Post date:** [January 16, 2025, 7:08am UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-timezone-with-tag-history/100156/15 "2025-01-16T07:08:09Z")

</div>

Yep, more than possible.
