Historian Data is Different 1 Hour #Gateway Current is 6.35 PM #But Data Historian show 5.35 PM

Dear All
I'm have Problem about Tag Historian
is Different 1 Hour on ignition version 8.1.31
#Gateway Current is 6.35 PM
#But Data Historian show 5.35 PM
Please Sent Solution for Problem
Thank you


Is the time zone of the designer different from the gateway? If so, the appearance of date/time values will be in the designer timezone.

1 Like

Dear pturmel
Time zone of the designer and gateway is similar
I use Asia/Bangkok

Dear pturmel
Time zone of the designer and gateway is similar
I use Asia/Bangkok

Consider printing out your date/time objects using system.date.format() with a format code that shows the time zone offset used at that point.

Dear Pturmel
I test print time zone according to your instructions,
result is picture as attach file.
and I recheck time zone of server, gateway, project designer , and database server for store historian. All of the above have the same value.

I'm very confused
Help me Please.

Thank you for support


Oh, I see it. You are asking for eight hour-long periods starting eight hours ago. Each row in the dataset has a timestamp for the beginning of the hour-long period it represents. Therefore, the last row's timestamp is an hour ago.

1 Like

Good catch! So they need to either change the point count to 9 or change the start date to -7 hours instead of -8 and that should fix it right?

No, not if they want actual data for the past hour. The dataset is correctly showing the past hour's data in the last row. That hour started one hour before now(). So, there's simply nothing wrong, and no timezone error at all. Simply a misunderstanding of what the requested data would "look like".

True, and I guess if he wants the current value as well, he'll have to change from point count to periodic and every 1 hour instead to get what he's probably intending to get from his binding. Otherwise point count evenly spaces the points out but starts at the start time, so you'll never get the current value.