Date format not same as Named Query in Table PRESPETIVE

[Adarsh_Shelar]

Hi all.
I was trying the fetch the alarm data from the database displayed in the Table.

This is the data type used in the database (mysql)

This is the named query data type used to fetch the data from the Database.

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.

i used the start and date in the tabel query binding for filter.

Properties used for the datetime picker component

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

Thank you

[JordanCClark]

Perspective table date showing as number

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.

[justinedwards.jle]

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

Two Tables Question Using Text Fields

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 [image]