# Format Table Component Data SQL Query

**URL:** <https://forum.inductiveautomation.com/t/format-table-component-data-sql-query/84864>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [January 28, 2024, 11:52pm UTC](https://forum.inductiveautomation.com/t/format-table-component-data-sql-query/84864 "2024-01-28T23:52:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eric\_Ervin](https://avatars.discourse-cdn.com/v4/letter/e/ecd19e/32.png) [@Eric\_Ervin](https://forum.inductiveautomation.com/u/Eric_Ervin)\
**Post date:** [January 28, 2024, 11:52pm UTC](https://forum.inductiveautomation.com/t/format-table-component-data-sql-query/84864/1 "2024-01-28T23:52:22Z")

</div>

I'm trying to format my table results on the component. Right now my timestamp result shows 1,706,485,821,374. I'd like to format this to a readable date time format. My database is Postgres if that matters at all. I couldn't find anything searching online that answered my question as I don't want to ask already answered questions if possible.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [January 29, 2024, 12:03am UTC](https://forum.inductiveautomation.com/t/format-table-component-data-sql-query/84864/2 "2024-01-29T00:03:12Z")

</div>

Workng from memory ...

Make sure you enter the database column name in each column's `columns.X.field` property.  
Set `render : date`.  
Set `dateformat` as desired.

---

<div class="post-metadata">

**Author:** ![Eric\_Ervin](https://avatars.discourse-cdn.com/v4/letter/e/ecd19e/32.png) [@Eric\_Ervin](https://forum.inductiveautomation.com/u/Eric_Ervin)\
**Post date:** [January 29, 2024, 12:05am UTC](https://forum.inductiveautomation.com/t/format-table-component-data-sql-query/84864/3 "2024-01-29T00:05:58Z")

</div>

I'm sorry, I'm not quite sure I understand what you mean.

---

<div class="post-metadata">

**Author:** ![Eric\_Ervin](https://avatars.discourse-cdn.com/v4/letter/e/ecd19e/32.png) [@Eric\_Ervin](https://forum.inductiveautomation.com/u/Eric_Ervin)\
**Post date:** [January 29, 2024, 1:04am UTC](https://forum.inductiveautomation.com/t/format-table-component-data-sql-query/84864/4 "2024-01-29T01:04:02Z")

</div>

I found it between you and the table component docs. Thank you