# Easy Chart Database Pen UTC time to CST time

**URL:** <https://forum.inductiveautomation.com/t/easy-chart-database-pen-utc-time-to-cst-time/16315>\
**Category:** Ignition\
**Created:** [December 13, 2017, 5:34pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen-utc-time-to-cst-time/16315 "2017-12-13T17:34:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [December 13, 2017, 5:34pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen-utc-time-to-cst-time/16315/1 "2017-12-13T17:34:50Z")

</div>

Making an Easy chart, Have a Database Pen grabbing a cycle time Y Column, my Time Column is in UTC. So when you go to view the data, the newest data is “in the future” (CST is -6 hours UTC).

Can I some how tell the Easy Chart to change the time showing to CST?? Should I be using a regular Chart to do those conversions??

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 13, 2017, 5:57pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen-utc-time-to-cst-time/16315/2 "2017-12-13T17:57:22Z")

</div>

You can’t do it from within Ignition. You need to use a database column that understands timezones and will trigger the conversion for you. In PostgreSQL, you would simple use the “Timestamp with Timezone” datatype. It stores everything in UTC and converts to/from that in every query based on the connection properties. If your database doesn’t have a column type that’ll work for you, you might need to create a view in the database that incorporates the conversion, and point your DB pens at that view instead of the table.

---

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [December 26, 2017, 4:33pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen-utc-time-to-cst-time/16315/3 "2017-12-26T16:33:11Z")

</div>

Thanks. For future reference ended up doing the conversion on the SQL table itself prior to doing the query against said table.