# Ignition Perspective Table

**URL:** <https://forum.inductiveautomation.com/t/ignition-perspective-table/93445>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 19, 2024, 8:27am UTC](https://forum.inductiveautomation.com/t/ignition-perspective-table/93445 "2024-07-19T08:27:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sudeep\_Kadlak](https://avatars.discourse-cdn.com/v4/letter/s/9f8e36/32.png) [@Sudeep\_Kadlak](https://forum.inductiveautomation.com/u/Sudeep_Kadlak)\
**Post date:** [July 19, 2024, 8:27am UTC](https://forum.inductiveautomation.com/t/ignition-perspective-table/93445/1 "2024-07-19T08:27:37Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/f/ffb260ccf347a07cec069188a3f5a0dc8e828a4c.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/9/59f6e411cce7d084d00ce2c78bb378f7ced04cdb.png)

"We're observing a discrepancy between the SQL database, where the time is logged as 2:00 AM, and the Ignition perspective table, which shows it as 1:51:10 AM. Do you have any insights into what might be causing this discrepancy?"

---

<div class="post-metadata">

**Author:** ![YF129701](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/yf129701/32/60498_2.png) [@YF129701](https://forum.inductiveautomation.com/u/YF129701)\
**Post date:** [July 19, 2024, 2:34pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-table/93445/2 "2024-07-19T14:34:39Z")

</div>

What does the column object's `dateFormat` look like for the StartDate and EndDate columns?