Hi !
I need to format a second count to "hh:mm:ss" using the query editor.
9876 => "02:44:36"
The second count is obtained with datetimeDiff([StartedAt], [FinishedAt], "second")
Metabase doesn't support second to time formating, SEC_TO_TIME()
, LPAD()
and MOD
/ %
.
How can I do this ? Any other way ?
Thx