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

**URL:** <https://forum.inductiveautomation.com/t/sqlite-database-adjusting-timestamp-format-and-centering-data-in-table-properties/92863>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [July 7, 2024, 12:57am UTC](https://forum.inductiveautomation.com/t/sqlite-database-adjusting-timestamp-format-and-centering-data-in-table-properties/92863 "2024-07-07T00:57:44Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Aiasa21](https://avatars.discourse-cdn.com/v4/letter/a/aeb1de/32.png) [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\
**Post date:** [July 7, 2024, 6:44am UTC](https://forum.inductiveautomation.com/t/sqlite-database-adjusting-timestamp-format-and-centering-data-in-table-properties/92863/2 "2024-07-07T06:44:03Z")

</div>

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

---

_[View the full topic](https://forum.inductiveautomation.com/t/sqlite-database-adjusting-timestamp-format-and-centering-data-in-table-properties/92863)._