SQLite Database: Adjusting Timestamp Format and Centering Data in Table Properties

[Aiasa21]

Hi, you can find all what you need under the columns properties, I cannot provide a screenshot now, but you have to set the columns name as in the sql query and then there are the align and the format properties to change.

Read this for example

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.