# SQLTag History Data

**URL:** <https://forum.inductiveautomation.com/t/sqltag-history-data/5930>\
**Category:** Ignition\
**Created:** [February 27, 2013, 1:53pm UTC](https://forum.inductiveautomation.com/t/sqltag-history-data/5930 "2013-02-27T13:53:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasonpdavid](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@jasonpdavid](https://forum.inductiveautomation.com/u/jasonpdavid)\
**Post date:** [February 27, 2013, 1:53pm UTC](https://forum.inductiveautomation.com/t/sqltag-history-data/5930/1 "2013-02-27T13:53:49Z")

</div>

I’ve recently discovered that when I run any charts for tags that the data leads into the future by about one hour. The values are correct up to the current time and then the current value is cast into the future. The values never catch up and the time continues to push. /\_

Any ideas on what can cause this? I’ve already checked the clocks on my client & server computers and they are correct.

Not sure if I did a great enough job in describing what is happening…

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [February 27, 2013, 4:18pm UTC](https://forum.inductiveautomation.com/t/sqltag-history-data/5930/2 "2013-02-27T16:18:44Z")

</div>

Are the project properties (in the designer) set to us the gateway timezone, or something else?

If this is not the issue, what version of Java and Ignition are you using?

---

<div class="post-metadata">

**Author:** ![jasonpdavid](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@jasonpdavid](https://forum.inductiveautomation.com/u/jasonpdavid)\
**Post date:** [February 27, 2013, 6:24pm UTC](https://forum.inductiveautomation.com/t/sqltag-history-data/5930/3 "2013-02-27T18:24:00Z")

</div>

It is set to Client Time Zone

Ignition Platform  
7.5.5 (b1255)

Java  
Version 7 Update 10

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [February 28, 2013, 9:13pm UTC](https://forum.inductiveautomation.com/t/sqltag-history-data/5930/4 "2013-02-28T21:13:34Z")

</div>

The charts (easy charts, I presume?) are set to realtime mode? Currently when the queried range exceeds the current time, the last value is simply returned for the future, so it sounds like for some reason the chart is asking for an extra hour. If it’s set to realtime, that would be very strange (especially if the starting time is correct for the range you want!), but if it’s a historical chart, or some other type of binding, perhaps the end time binding could be off.

We’ve also noticed that when using the tag history binding with a time interval, it tends to round up one interval. So, for example, if you had it bound to the last 8 hours in 1 hour intervals, you might end up with this behavior.

We’re going to soon change the behavior of returning the last stored value for time in the future, but that’s not really a big deal right now, the main question is how the requested time frame is getting offset.

Regards,