Power table does not display time period HH:MM etc

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?

Ignition version?

In 7.9 right click go to customizers/table customizer

1 Like

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