Historian Timestamp Interpretation

Ignition
1

Dear Friends,

I’d would like to know how can i interpret the timestamp value in the history tables. Ignition write a raw value and i want to convert this number into a human legible data and time value.

Thanks in advance

2

from_unixtime(t_stamp/1000) for MySQL.

What DB are you using?

3

You can do something like this for MS SQL Server:

SELECT DATEADD(s,t_stamp/1000,'1970-01-01 00:00:00') FROM sqlth_data...
4

techerdone, Dave,

In fact I’m using MySQL, so your solution works fine. I was doing something similar, but It was a pretty dirty piece of code.

Thanks!