# Named Query Table Date Time Column

**URL:** <https://forum.inductiveautomation.com/t/named-query-table-date-time-column/88524>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 8, 2024, 3:17pm UTC](https://forum.inductiveautomation.com/t/named-query-table-date-time-column/88524 "2024-04-08T15:17:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aron\_Grzywaczewski](https://avatars.discourse-cdn.com/v4/letter/a/439d5e/32.png) [@Aron\_Grzywaczewski](https://forum.inductiveautomation.com/u/Aron_Grzywaczewski)\
**Post date:** [April 8, 2024, 3:17pm UTC](https://forum.inductiveautomation.com/t/named-query-table-date-time-column/88524/1 "2024-04-08T15:17:56Z")

</div>

I am returning date and time in a named query to a perspective table:

named query result set:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/e/fecb85cd346d9c3fd8f4a43692a7e2bc8de93e62.png)

but the column data displays something like this:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/a/3ac262810f9097b38f007da34d30920d8bc9017d.png)

Any idea how to fix this?

---

<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:** [April 8, 2024, 3:22pm UTC](https://forum.inductiveautomation.com/t/named-query-table-date-time-column/88524/2 "2024-04-08T15:22:12Z")

</div>

In the table's columns property, configure that column to render dates. Under the hood, Ignition datetime values are UTC milliseconds, and since JSON doesn't have that, they are transmitted as long integers. Ignition's components (most of them) understand how to deal with them, but for some components, they need a cue. (You might actually want to display 64-bit integers in a table.)

---

<div class="post-metadata">

**Author:** ![Aron\_Grzywaczewski](https://avatars.discourse-cdn.com/v4/letter/a/439d5e/32.png) [@Aron\_Grzywaczewski](https://forum.inductiveautomation.com/u/Aron_Grzywaczewski)\
**Post date:** [April 8, 2024, 3:31pm UTC](https://forum.inductiveautomation.com/t/named-query-table-date-time-column/88524/3 "2024-04-08T15:31:59Z")

</div>

I configured it as date column but I still get the same result

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/7/679b747983c03da23293fbe0cdad83dedb919fd8.png)

---

<div class="post-metadata">

**Author:** ![Aron\_Grzywaczewski](https://avatars.discourse-cdn.com/v4/letter/a/439d5e/32.png) [@Aron\_Grzywaczewski](https://forum.inductiveautomation.com/u/Aron_Grzywaczewski)\
**Post date:** [April 8, 2024, 3:34pm UTC](https://forum.inductiveautomation.com/t/named-query-table-date-time-column/88524/4 "2024-04-08T15:34:36Z")

</div>

ok resolved, I had to provide the field name i.e. column name:

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/5/15e0224c4fcda8eb80af940a96d4871ec3386f77.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/7/072727ac42d4fbe7f8d158ae4e2f0bf83f9819a8.png)

---

<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:** [April 8, 2024, 3:44pm UTC](https://forum.inductiveautomation.com/t/named-query-table-date-time-column/88524/5 "2024-04-08T15:44:10Z")

</div>

> [@Aron\_Grzywaczewski](#):
>
> provide the field name i.e. column name:

Yes, that is required for every column in columns for reliable behavior.