Transaction group date format

Ignition
1

How can I change the format of t_stamp to a string ‘yyyy-mm-dd hh-mm-ss’ ?

It’s writing it in that format in my transaction group, and it’s a little annoying actually.

The testing query works and it should return all timestamps greater than that one, regardless of format there

2 
SELECT count(count1_ndx)-1 
FROM count1 
where t_stamp >= 1639054080

I get the same result: 18

3

image

you can use this to convert (m)s to datedates there probabaly is another/better way too)

convert(datetime, dateadd(s, 1639054080, '1970-01-01'))
convert(datetime, dateadd(ms, 1639054080257, '1970-01-01'))
1 Like