# Table DateTime working oddly with Named Query to Populate

**URL:** <https://forum.inductiveautomation.com/t/table-datetime-working-oddly-with-named-query-to-populate/100167>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [December 23, 2024, 2:49pm UTC](https://forum.inductiveautomation.com/t/table-datetime-working-oddly-with-named-query-to-populate/100167 "2024-12-23T14:49:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AUSDIV](https://avatars.discourse-cdn.com/v4/letter/a/e47c2d/32.png) [@AUSDIV](https://forum.inductiveautomation.com/u/AUSDIV)\
**Post date:** [December 23, 2024, 2:49pm UTC](https://forum.inductiveautomation.com/t/table-datetime-working-oddly-with-named-query-to-populate/100167/1 "2024-12-23T14:49:32Z")

</div>

In the imagine you will see how the dataset when you click the table diagram shows the date and time format as a non epoch value. You will also see the column is set to date and format is set properly. Although, it seems the named Query over-rides the column properties. The thing is the named query is converting the t\_stamp from epoch time already, and for some reason the table when showing the named query converts it back to Epoch automatically. If I alter my query to show the t\_stamp natively, the table still shows it as Epoch.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/b/8bd329ba40a2348ca287909610b0ce8699e5d7f8.png)

---

<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:** [December 23, 2024, 2:51pm UTC](https://forum.inductiveautomation.com/t/table-datetime-working-oddly-with-named-query-to-populate/100167/2 "2024-12-23T14:51:43Z")

</div>

You need to set  
`columns.0.field : DateAndTime`  
so that it can apply the rest of your settings.

Setting the field property for every column is usually a good idea.

---

<div class="post-metadata">

**Author:** ![AUSDIV](https://avatars.discourse-cdn.com/v4/letter/a/e47c2d/32.png) [@AUSDIV](https://forum.inductiveautomation.com/u/AUSDIV)\
**Post date:** [December 23, 2024, 3:01pm UTC](https://forum.inductiveautomation.com/t/table-datetime-working-oddly-with-named-query-to-populate/100167/3 "2024-12-23T15:01:13Z")

</div>

Thanks a ton, that was a simple fix.