# Gateway log export does not contain Time

**URL:** <https://forum.inductiveautomation.com/t/gateway-log-export-does-not-contain-time/19284>\
**Category:** Ignition\
**Tags:** ignition79, database\
**Created:** [August 16, 2018, 3:09pm UTC](https://forum.inductiveautomation.com/t/gateway-log-export-does-not-contain-time/19284 "2018-08-16T15:09:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bdecelles](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bdecelles/32/5713_2.png) [@bdecelles](https://forum.inductiveautomation.com/u/bdecelles)\
**Post date:** [August 16, 2018, 3:09pm UTC](https://forum.inductiveautomation.com/t/gateway-log-export-does-not-contain-time/19284/1 "2018-08-16T15:09:32Z")

</div>

When exporting the gateway log there is no Datetime timestamp; however, there is a datetime when viewing the log in the gateway webpage. The timestamp that is present in the exported log is more of an index. Is there a way to get the actual date-time from a log exported from the gateway?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [August 16, 2018, 3:41pm UTC](https://forum.inductiveautomation.com/t/gateway-log-export-does-not-contain-time/19284/2 "2018-08-16T15:41:54Z")

</div>

The tstamp column in log exports _is_ a timestamp - it’s a count of milliseconds since epoch (because that’s how Java stores date/times). Depending on where you’re interpreting that data, you can usually just divide by 1000 and use a [built in](https://docs.python.org/2.7/library/datetime.html#datetime.datetime.fromtimestamp) [function](https://www.sqlite.org/lang_datefunc.html) to do the conversion.

---

<div class="post-metadata">

**Author:** ![bdecelles](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bdecelles/32/5713_2.png) [@bdecelles](https://forum.inductiveautomation.com/u/bdecelles)\
**Post date:** [August 16, 2018, 3:43pm UTC](https://forum.inductiveautomation.com/t/gateway-log-export-does-not-contain-time/19284/3 "2018-08-16T15:43:23Z")

</div>

I converted from epoch, but didn’t divide by 1000. That made it work. Thanks!