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