# What fomrat is "t\_stamp" in tag history database?

**URL:** <https://forum.inductiveautomation.com/t/what-fomrat-is-t-stamp-in-tag-history-database/53444>\
**Category:** Ignition\
**Created:** [November 24, 2021, 6:22pm UTC](https://forum.inductiveautomation.com/t/what-fomrat-is-t-stamp-in-tag-history-database/53444 "2021-11-24T18:22:35Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Post date:** [November 24, 2021, 6:22pm UTC](https://forum.inductiveautomation.com/t/what-fomrat-is-t-stamp-in-tag-history-database/53444/1 "2021-11-24T18:22:35Z")

</div>

Hello all,

I am using the tag history database, and there is a column there called t\_stamp. I do not understand what the format is? Is there any way I can change to the actual date format? Just like the start date/ end date of the named query? I am planning to use this database in my named query and I am planning to create a chart data based on t\_stamp.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/2/726d8f3961c300efe530ffaa5e107a2a783d46ca.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:** [November 24, 2021, 6:25pm UTC](https://forum.inductiveautomation.com/t/what-fomrat-is-t-stamp-in-tag-history-database/53444/2 "2021-11-24T18:25:11Z")

</div>

To avoid compatibility problems across database brands, tag history stores 64-bit milliseconds UTC, which matches the internal implementation of java.util.Date–Ignition’s platform-wide date/time object.

---

<div class="post-metadata">

**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Post date:** [November 24, 2021, 6:27pm UTC](https://forum.inductiveautomation.com/t/what-fomrat-is-t-stamp-in-tag-history-database/53444/3 "2021-11-24T18:27:50Z")

</div>

I see. Thank you, Phill for your response.  
So I am trying to use that t\_stamp as my domain key in my report to create a chart but nothing is showing up, I thought the problem should be with the t\_stamp. So your suggestion is that I do not change the format, correct?

---

<div class="post-metadata">

**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\
**Post date:** [November 24, 2021, 6:33pm UTC](https://forum.inductiveautomation.com/t/what-fomrat-is-t-stamp-in-tag-history-database/53444/4 "2021-11-24T18:33:50Z")

</div>

No, Ignition does that for you. Use a Tag History Binding instead. For a report, this is called Tag Historian Query.

---

<div class="post-metadata">

**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Post date:** [November 24, 2021, 6:42pm UTC](https://forum.inductiveautomation.com/t/what-fomrat-is-t-stamp-in-tag-history-database/53444/5 "2021-11-24T18:42:00Z")

</div>

I will check that. Thank you!

---

<div class="post-metadata">

**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Post date:** [November 24, 2021, 6:52pm UTC](https://forum.inductiveautomation.com/t/what-fomrat-is-t-stamp-in-tag-history-database/53444/6 "2021-11-24T18:52:25Z")

</div>

I just checked the tag history query that would work the best. Thank you!