# Tag history stores tag value with wrong timestamps

**URL:** <https://forum.inductiveautomation.com/t/tag-history-stores-tag-value-with-wrong-timestamps/88380>\
**Category:** Ignition\
**Tags:** database, ignition81, perspective\
**Created:** [April 4, 2024, 9:12pm UTC](https://forum.inductiveautomation.com/t/tag-history-stores-tag-value-with-wrong-timestamps/88380 "2024-04-04T21:12:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ahad99.shalwani](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ahad99.shalwani/32/76824_2.png) [@ahad99.shalwani](https://forum.inductiveautomation.com/u/ahad99.shalwani)\
**Post date:** [April 4, 2024, 9:12pm UTC](https://forum.inductiveautomation.com/t/tag-history-stores-tag-value-with-wrong-timestamps/88380/1 "2024-04-04T21:12:03Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/6/6627f01150d7431f23db9c65068f7cbd69319fd6.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/7/b7009178d2725bba8e066d998b8e1788765f6838.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/c/bc0a9fddf97c315577406b071c1a2a8a9a2b4e72.png)

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

Problem:  
I have a string tag with history enabled that stores string value in the DB table. When I call this table to show data then it shows wrong time. As it can be seen in the image 2 the gateway time is different and in image 3 the timestamp it shows is different. The named query is attached in the last image. What is the issue? The time is running behind 12 hrs.

---

<div class="post-metadata">

**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Post date:** [April 4, 2024, 9:50pm UTC](https://forum.inductiveautomation.com/t/tag-history-stores-tag-value-with-wrong-timestamps/88380/2 "2024-04-04T21:50:09Z")

</div>

Is your database on a different machine?

---

<div class="post-metadata">

**Author:** ![ahad99.shalwani](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ahad99.shalwani/32/76824_2.png) [@ahad99.shalwani](https://forum.inductiveautomation.com/u/ahad99.shalwani)\
**Post date:** [April 4, 2024, 9:53pm UTC](https://forum.inductiveautomation.com/t/tag-history-stores-tag-value-with-wrong-timestamps/88380/3 "2024-04-04T21:53:48Z")

</div>

Yes

---

<div class="post-metadata">

**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Post date:** [April 4, 2024, 9:54pm UTC](https://forum.inductiveautomation.com/t/tag-history-stores-tag-value-with-wrong-timestamps/88380/4 "2024-04-04T21:54:20Z")

</div>

Check the time settings of the gateway machine vs the database machine.