# Convert Epoch Time in SQL Query

**URL:** <https://forum.inductiveautomation.com/t/convert-epoch-time-in-sql-query/88644>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 10, 2024, 3:04pm UTC](https://forum.inductiveautomation.com/t/convert-epoch-time-in-sql-query/88644 "2024-04-10T15:04:11Z")\
**Posts on this page:** 1\
**Page:** 2

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [April 10, 2024, 4:02pm UTC](https://forum.inductiveautomation.com/t/convert-epoch-time-in-sql-query/88644/21 "2024-04-10T16:02:29Z")

</div>

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:

```auto
SELECT tagpath FROM sqlth_te WHERE id = 161

```

You should get the path to the tag back.

[Previous page](https://forum.inductiveautomation.com/t/convert-epoch-time-in-sql-query/88644.md?page=1)