# Format Timestamp in Table not working

**URL:** <https://forum.inductiveautomation.com/t/format-timestamp-in-table-not-working/4947>\
**Category:** Ignition\
**Created:** [August 7, 2012, 6:13pm UTC](https://forum.inductiveautomation.com/t/format-timestamp-in-table-not-working/4947 "2012-08-07T18:13:27Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\
**Post date:** [August 7, 2012, 6:13pm UTC](https://forum.inductiveautomation.com/t/format-timestamp-in-table-not-working/4947/1 "2012-08-07T18:13:27Z")

</div>

I have a table that is being populated from returned dataset using system.db.createSProcCall. One of the column in the table is a date/time, but the table customizer will not reformat the column. when i view the data set in the designer and look at the column type it says Timestamp. How can i format the date in this column?

Thank you,

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [August 7, 2012, 7:09pm UTC](https://forum.inductiveautomation.com/t/format-timestamp-in-table-not-working/4947/2 "2012-08-07T19:09:47Z")

</div>

After you change the date time format in the date formats window are you selecting ok on that window? I have been trying to recreate this here without any luck. The only way that it will not change the date and time format is if I select ok on the table customizer window before selecting ok in the date format window.

---

<div class="post-metadata">

**Author:** ![Jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\
**Post date:** [August 7, 2012, 8:26pm UTC](https://forum.inductiveautomation.com/t/format-timestamp-in-table-not-working/4947/3 "2012-08-07T20:26:53Z")

</div>

that does not seem to be the problem. See if you can reproduce the problem with the attached window.  
[TimestampFormatIssue.proj](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f00850923546ab8a8f3b70f7d8747924f610c054.proj) (41.1 KB)

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [August 7, 2012, 8:34pm UTC](https://forum.inductiveautomation.com/t/format-timestamp-in-table-not-working/4947/4 "2012-08-07T20:34:25Z")

</div>

Hmmm, its still not performing like you stated. What version of Ignition are you using? I have Ignition 7.5.1 installed on my machine, I am reattaching your table if you would like to take a look at it. But, keep in mind that you will need Ignition 7.5.1 or newer to view it.  
[test\_TimestampFormatIssue\_2012-08-07\_1331.proj](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a79483d2146c6eaad44edd9f0eaef6839efa6f67.proj) (41.2 KB)

---

<div class="post-metadata">

**Author:** ![Jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\
**Post date:** [August 7, 2012, 8:35pm UTC](https://forum.inductiveautomation.com/t/format-timestamp-in-table-not-working/4947/5 "2012-08-07T20:35:40Z")

</div>

we are running 7.4.3. i will try the issue on my development machine.

---

<div class="post-metadata">

**Author:** ![Jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\
**Post date:** [August 7, 2012, 9:57pm UTC](https://forum.inductiveautomation.com/t/format-timestamp-in-table-not-working/4947/6 "2012-08-07T21:57:29Z")

</div>

The problem is when you use system.db.createSProcCall, system.db.execSProcCall, and getResultSet() and the returned dataset has a date the table customizer will not format the date column.

I have changed my code for the time being to call the stored procedure using system.db.runPrepQuery. I then convert the Python dataset returned into a Ignition dataset using system.dataset.toDataSet().

now the date column will format in the table.

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [August 7, 2012, 10:14pm UTC](https://forum.inductiveautomation.com/t/format-timestamp-in-table-not-working/4947/7 "2012-08-07T22:14:22Z")

</div>

Cool, glad to hear you got it to work the way you wanted it to.