# Power table does not display time period HH:MM etc

**URL:** <https://forum.inductiveautomation.com/t/power-table-does-not-display-time-period-hh-mm-etc/48249>\
**Category:** Ignition\
**Created:** [June 27, 2021, 7:57pm UTC](https://forum.inductiveautomation.com/t/power-table-does-not-display-time-period-hh-mm-etc/48249 "2021-06-27T19:57:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hewking32](https://avatars.discourse-cdn.com/v4/letter/h/b5ac83/32.png) [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\
**Post date:** [June 27, 2021, 7:57pm UTC](https://forum.inductiveautomation.com/t/power-table-does-not-display-time-period-hh-mm-etc/48249/1 "2021-06-27T19:57:08Z")

</div>

hi  
I have simple SQL query returning time period but when connected to the data property of the power table it displays as date instead of time period HH:MM:SS

Any idea how to change it?  
Regards

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [June 27, 2021, 11:13pm UTC](https://forum.inductiveautomation.com/t/power-table-does-not-display-time-period-hh-mm-etc/48249/2 "2021-06-27T23:13:43Z")

</div>

Ignition version?

In 7.9 right click go to customizers/table customizer

---

<div class="post-metadata">

**Author:** ![hewking32](https://avatars.discourse-cdn.com/v4/letter/h/b5ac83/32.png) [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\
**Post date:** [June 27, 2021, 11:30pm UTC](https://forum.inductiveautomation.com/t/power-table-does-not-display-time-period-hh-mm-etc/48249/3 "2021-06-27T23:30:22Z")

</div>

Good advice however in my case i had to add command  
DATE\_FORMAT(TIME\_TO\_FORMAT ,’%H:%i:%s’) AS “Formatted Duration”