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
where t_stamp >= 1639054080
I get the same result: 18
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'))