# Date format not same as Named Query in Table PRESPETIVE

**URL:** <https://forum.inductiveautomation.com/t/date-format-not-same-as-named-query-in-table-prespetive/70062>\
**Category:** Ignition\
**Tags:** python, database, scripting, ignition81, perspective\
**Created:** [February 20, 2023, 1:04pm UTC](https://forum.inductiveautomation.com/t/date-format-not-same-as-named-query-in-table-prespetive/70062 "2023-02-20T13:04:56Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [February 20, 2023, 1:13pm UTC](https://forum.inductiveautomation.com/t/date-format-not-same-as-named-query-in-table-prespetive/70062/2 "2023-02-20T13:13:50Z")

</div>

> [@Perspective table date showing as number](https://forum.inductiveautomation.com/t/perspective-table-date-showing-as-number/59159):
>
> I have a table I am showing in perspective and my time stamp is displaying as a number instead of a date. when I execute the name query is shows as a date. the column is listed as date format and showing the date in the dataset editor. but for some reason it is displaying as a number in the table.

---

_[View the full topic](https://forum.inductiveautomation.com/t/date-format-not-same-as-named-query-in-table-prespetive/70062)._