# Wrong hour in table from Perspective

**URL:** <https://forum.inductiveautomation.com/t/wrong-hour-in-table-from-perspective/89390>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 24, 2024, 6:43pm UTC](https://forum.inductiveautomation.com/t/wrong-hour-in-table-from-perspective/89390 "2024-04-24T18:43:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gilberto\_Morin](https://avatars.discourse-cdn.com/v4/letter/g/7feea3/32.png) [@Gilberto\_Morin](https://forum.inductiveautomation.com/u/Gilberto_Morin)\
**Post date:** [April 24, 2024, 6:43pm UTC](https://forum.inductiveautomation.com/t/wrong-hour-in-table-from-perspective/89390/1 "2024-04-24T18:43:20Z")

</div>

![Capture](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/b/cb24c202be6ace635738500c1a58a60b575c3910.png)  
I have the same query in both sides, in the database and in the table from perspective, but the table from perspective shows the a wrong hour.

---

<div class="post-metadata">

**Author:** ![aspatchek2013](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aspatchek2013/32/85339_2.png) [@aspatchek2013](https://forum.inductiveautomation.com/u/aspatchek2013)\
**Post date:** [April 24, 2024, 8:35pm UTC](https://forum.inductiveautomation.com/t/wrong-hour-in-table-from-perspective/89390/2 "2024-04-24T20:35:44Z")

</div>

If the column is rendered as a 'date', I believe the table will automatically offset Date objects to whichever timezone is set as your Project Timezone. What timezone is your gateway in? What timezone is your client/designer in? What is the Project Timezone setting?

[Perspective Project Properties | Ignition User Manual (inductiveautomation.com)](https://docs.inductiveautomation.com/docs/8.1/ignition-modules/perspective/perspective-project-properties#general)

Edit: You may need to restart your designer once you change the Project Timezone property.