Data_table displays time incorectly

this is the first time i am playing with plotly and dash, i tried to connect into my mysql and simply displaying the content… seems like it has problems displaying TIME

this is what i get

all others data are fine, just plain time is not. maybe i am doing something wrong but i have no idea what.

any tips or sgesstiongs on how to fix it?

By default, the table does not do any special formatting on the data it receives, if it displays P0D hhHmmMssS, that’s because that’s what it received. There’s currently no built-in capability to format this type of data. One solution might be to format the mysql output with some variation of SELECT TIME_FORMAT(foo_time, ''%r') FROM bar.

1 Like