Convert Epoch Time in SQL Query

In order for this table to have data, it must have a tag. Unless there is some weird TransactionGroup or Gateway Event scripting magic going on that is inserting this data manually, in which case Oy!.

If you run this:

SELECT tagpath FROM sqlth_te WHERE id = 161

You should get the path to the tag back.

2 Likes