I need a stopwatch time format i.e. 00:01:10 for 70 seconds

Get Help
1

Hello,
my PostgreSql-Table holds a time column with data like that:
00:02:07
00:00:06

I was not able to find a way to visualize this times correctly in Metabase. It looks like that:
Auswahl_121

Is it possible to change this behavior?
The screenshot-times should be following:

00:00:03
00:00:05
00:00:04

Thank you

2

Hi @wuarmin
You would have to cast the column to a string like
SELECT CAST(time_column AS VARCHAR) FROM table)

1 Like