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.