# Ignition Table with Named Query Binding

**URL:** <https://forum.inductiveautomation.com/t/ignition-table-with-named-query-binding/99524>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [December 6, 2024, 1:37pm UTC](https://forum.inductiveautomation.com/t/ignition-table-with-named-query-binding/99524 "2024-12-06T13:37:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pascal\_Bauer](https://avatars.discourse-cdn.com/v4/letter/p/9de053/32.png) [@Pascal\_Bauer](https://forum.inductiveautomation.com/u/Pascal_Bauer)\
**Post date:** [December 6, 2024, 1:37pm UTC](https://forum.inductiveautomation.com/t/ignition-table-with-named-query-binding/99524/1 "2024-12-06T13:37:55Z")

</div>

My Question is:

When the result of a Named Query is a Dataset and the first Column contains the Start Date in UnixFormat (Integer Seconds since 1.1.1970).

How can i convert all values in the first column to show the actual Date DD.MM.YYYY ss:mm:hh?

---

<div class="post-metadata">

**Author:** ![ryan.perretta](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.perretta/32/75110_2.png) [@ryan.perretta](https://forum.inductiveautomation.com/u/ryan.perretta)\
**Post date:** [December 6, 2024, 2:20pm UTC](https://forum.inductiveautomation.com/t/ignition-table-with-named-query-binding/99524/2 "2024-12-06T14:20:26Z")

</div>

If you use the columns property of the perspective table you can specify some formatting rules.

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

Simply enter the column name in `field` (exactly matching how it is in the data) set the render mode as `date` and then select the desired `dateFormat`.

This is the result I get when using millisecond time, if it does not work for you try converting from seconds to millis.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/d/ed1f5b470588f3fc5412652fb04a2c27ae4bcec2.png)

NOTE:  
If you need to alter the format beyond the preset options you can customize it further to do something like DD-MM-YYYY by manually typing it into the `dateFormat` property