# T\_stamp column storing as a "text" datatype

**URL:** <https://forum.inductiveautomation.com/t/t-stamp-column-storing-as-a-text-datatype/66360>\
**Category:** Ignition\
**Created:** [November 10, 2022, 6:29pm UTC](https://forum.inductiveautomation.com/t/t-stamp-column-storing-as-a-text-datatype/66360 "2022-11-10T18:29:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Justin\_Szatkowski](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@Justin\_Szatkowski](https://forum.inductiveautomation.com/u/Justin_Szatkowski)\
**Post date:** [November 10, 2022, 6:29pm UTC](https://forum.inductiveautomation.com/t/t-stamp-column-storing-as-a-text-datatype/66360/1 "2022-11-10T18:29:16Z")

</div>

Hello,

I have configured a transaction group to collect data on a schedule. However, when automatically storing the time data to a "t\_stamp" column, the datatype gets put as "text". Therefore, when trying to run a select query by date, I cannot do so. I have attached some screenshots for reference. Is there any way I can change the datatype to be a datetime, or some way I can filter based on the "text" timestamp?  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/e/fea9344364c2aff0dad78dc2587f2906afd46d74.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/0/002c3b4d04f47062a2cb8ef600e9f8ee383a4adb.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/e/3e779b53d328268862a9ac0816f3155fee0b6be3.png)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [November 10, 2022, 6:31pm UTC](https://forum.inductiveautomation.com/t/t-stamp-column-storing-as-a-text-datatype/66360/2 "2022-11-10T18:31:40Z")

</div>

Show us the data type for the t\_stamp column in the database. It looks like it is set as TEXT.  
How did you create the table?

---

<div class="post-metadata">

**Author:** ![Justin\_Szatkowski](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@Justin\_Szatkowski](https://forum.inductiveautomation.com/u/Justin_Szatkowski)\
**Post date:** [November 10, 2022, 7:00pm UTC](https://forum.inductiveautomation.com/t/t-stamp-column-storing-as-a-text-datatype/66360/3 "2022-11-10T19:00:05Z")

</div>

It is the bottom image. The datatype for t\_stamp is "TEXT". This is created as the timestamp column in the transaction group (per the first image).