Power table does not display time period HH:MM etc

Ignition
1

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

2

Ignition version?

In 7.9 right click go to customizers/table customizer

1 Like
3

Good advice however in my case i had to add command
DATE_FORMAT(TIME_TO_FORMAT ,’%H:%i:%s’) AS “Formatted Duration”