T_stamp column storing as a "text" datatype

Ignition
1

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
image
image

2

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?

3

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).