Wrong datetime format in table

Ignition
1

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

2

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

2 Likes
3

Thank you, that solved my problem.

1 Like
4

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
image328×441 12.6 KB

5

Be sure to put a field name in the column data.

image
image341×456 18 KB

3 Likes
6

Thank you, sometimes you look past the basics. :man_facepalming:

7

Many of the column properties won't work if the field is not specified. Beware!