# 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:** ignition81, scripting, database, python, 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:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adarsh\_Shelar](https://avatars.discourse-cdn.com/v4/letter/a/f07891/32.png) [@Adarsh\_Shelar](https://forum.inductiveautomation.com/u/Adarsh_Shelar)\
**Post date:** [February 20, 2023, 1:04pm UTC](https://forum.inductiveautomation.com/t/date-format-not-same-as-named-query-in-table-prespetive/70062/1 "2023-02-20T13:04:56Z")

</div>

Hi all.  
I was trying the fetch the alarm data from the database displayed in the Table.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/6/760972c8000730a1582abaa6738bf45fb7cd15bd.png)  
This is the data type used in the database ( **mysql** )

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/2/f27b0f66337375b5811b9ed43d02a8e45864ba61.png)  
This is the named query data type used to fetch the data from the Database.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/8/a85f7c353c4df5fd612fad70c3b7d2ffb4d4feb4.png)  
so here I am not Geeting the same date time format as its executed in the Named query.  
some different date format format getting in the table while filtering.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/0/104c81828bbd0679c2e60dfe531aa27b57439927.png)  
i used the start and date in the tabel query binding for filter.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/2/f243c47ee8d6d4792546d8b96b47480d556e030f.png)  
Properties used for the **datetime picker component**

so **How to get the proper date time format in the Table**

Thank you 💥

---

<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.

---

<div class="post-metadata">

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

</div>

Here's another forum post where the same problem was solved:

> [@Two Tables Question Using Text Fields](https://forum.inductiveautomation.com/t/two-tables-question-using-text-fields/64485/9):
>
> you need to add a mapping to those three text fields to map their values to a datetime Here i added a custom property called valueIn (that’s where you’d be writing your value to instead of the text property) Then add a binding on text to this.custom.valueIn and finally a Format Transform setup with whichever datetime format you want to display