# Wrong datetime format in table **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [April 3, 2025, 8:29am UTC](https://forum.inductiveautomation.com/t/wrong-datetime-format-in-table/104633 "2025-04-03T08:29:05Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Thomas\_Tornblom](https://avatars.discourse-cdn.com/v4/letter/t/c67d28/32.png) [@Thomas\_Tornblom](https://forum.inductiveautomation.com/u/Thomas_Tornblom)\ **Post date:** [April 3, 2025, 8:29am UTC](https://forum.inductiveautomation.com/t/wrong-datetime-format-in-table/104633/1 "2025-04-03T08:29:05Z")
I have a problem I don't understand, maybe it's a simlpe problem but I have tried to solve it and failed. I have a named query that returns results from a table that I want to show in Perspective. The return from the named query looks like this: "#NAMES" "ID","CREATED","TEXT","CLEAREDSTATE","CLEARED" "#TYPES" "D","date","str","D","date" "#ROWS","1" "5092.0","2025-01-20 10:02:42.529","Kran 1 rapporterar felkod 121 : Kan ej utföra körorder","1.0","2025-01-20 10:07:42.625" The text is in Swedish so you might not understand it but as you can see there are dates and times in the result. But when I present it it looks like this: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/d/edacff5bb292f605be7de25887665ffe40687aab.png) The dates and times seem to be in unix format and nanoseconds, not at all what the query returns or what I want to display. I have tried various transfers but the result is always the same. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [April 3, 2025, 8:36am UTC](https://forum.inductiveautomation.com/t/wrong-datetime-format-in-table/104633/2 "2025-04-03T08:36:00Z")
It's a pain, but you'll need to create a column in the props.columns for each of your fields, then you can set your Unix timestamp fields to be render as a date ---
**Author:** ![Thomas\_Tornblom](https://avatars.discourse-cdn.com/v4/letter/t/c67d28/32.png) [@Thomas\_Tornblom](https://forum.inductiveautomation.com/u/Thomas_Tornblom)\ **Post date:** [April 3, 2025, 8:56am UTC](https://forum.inductiveautomation.com/t/wrong-datetime-format-in-table/104633/3 "2025-04-03T08:56:37Z")
Thank you, that solved my problem. ---
**Author:** ![nlbolack](https://avatars.discourse-cdn.com/v4/letter/n/77aa72/32.png) [@nlbolack](https://forum.inductiveautomation.com/u/nlbolack)\ **Post date:** [April 14, 2025, 5:32pm UTC](https://forum.inductiveautomation.com/t/wrong-datetime-format-in-table/104633/4 "2025-04-14T17:32:07Z")
I'm having the same issue but can't get the formatting to work for me. Value in database "2025-04-11 01:26:51.000" but displays as "1,744,349,216,000" no matter how I change the date format of the column. I have to missing something but I'm at a loss. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/6/d6421b8583828973f86c3c7850e5f372e97094a8.png) ---
**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:** [April 14, 2025, 5:35pm UTC](https://forum.inductiveautomation.com/t/wrong-datetime-format-in-table/104633/5 "2025-04-14T17:35:32Z")
Be sure to put a field name in the column data. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/a/ca4a2ddec6d3c33609886ac65914f1dc50522271.png) ---
**Author:** ![nlbolack](https://avatars.discourse-cdn.com/v4/letter/n/77aa72/32.png) [@nlbolack](https://forum.inductiveautomation.com/u/nlbolack)\ **Post date:** [April 14, 2025, 6:55pm UTC](https://forum.inductiveautomation.com/t/wrong-datetime-format-in-table/104633/6 "2025-04-14T18:55:06Z")
Thank you, sometimes you look past the basics. 🤦‍♂️ ---
**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:** [April 14, 2025, 7:02pm UTC](https://forum.inductiveautomation.com/t/wrong-datetime-format-in-table/104633/7 "2025-04-14T19:02:45Z")
Many of the column properties won't work if the `field` is not specified. Beware!