Datatype not changing in MYSQL database

I want to change the datatype 't_stamp' to datetime format,
But its not allowing to me change and by default the tables got created with datatype as 'BigInt'.

If you change the datatype then the historian won't be able to write to it. t_stamp is an integer and stored in milliseconds since 1970-01-01 00:00:00. t_stamp values are stored in UTC so that you don't have to worry about timezones and daylight savings. This is common in database applications and the correct way to do it.

t_stamp values are converted to human-readable datetime formats at the point of display by the "rendering" mode of the component displaying the value.

1 Like