# Timestamps and timezones and postgres

**URL:** <https://forum.inductiveautomation.com/t/timestamps-and-timezones-and-postgres/1889>\
**Category:** Ignition\
**Created:** [June 2, 2010, 10:32pm UTC](https://forum.inductiveautomation.com/t/timestamps-and-timezones-and-postgres/1889 "2010-06-02T22:32:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [June 2, 2010, 10:32pm UTC](https://forum.inductiveautomation.com/t/timestamps-and-timezones-and-postgres/1889/1 "2010-06-02T22:32:50Z")

</div>

When you create a timestamp column in PostgreSQL you have to specify if it’s with out without the timezone.

Does Ignition make any difference between the two when it stores a timestamp?

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [June 3, 2010, 10:52pm UTC](https://forum.inductiveautomation.com/t/timestamps-and-timezones-and-postgres/1889/2 "2010-06-03T22:52:13Z")

</div>

Ignition’s dates are without timezone, so this setting will affect how those timezones are interpreted once they go into the database.

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [June 7, 2010, 3:08am UTC](https://forum.inductiveautomation.com/t/timestamps-and-timezones-and-postgres/1889/3 "2010-06-07T03:08:16Z")

</div>

Found my problem, postgresql can have it’s own timezone configured separate for the o/s. I my case it was configured to be GMT. As soon as I commented out the TZ line in postgresql.conf, time stamps in the db started to make sense.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [June 14, 2010, 5:46pm UTC](https://forum.inductiveautomation.com/t/timestamps-and-timezones-and-postgres/1889/4 "2010-06-14T17:46:27Z")

</div>

Glad you got it figured out!