Search code examples
metabase

Metabase displays wrong time format

My Data are stored in a MySql Database and i use Metabaseto display the data.

In phpMyAdmineverything looks like it should, but in Metabase the Dates are displayed like they should. The two datetimes types do not really matter but the time type looks like a date altough it's a time.

What can i do so that the time is displayed correctly?

Table Structure:

enter image description here

Table Data:

enter image description here

Metabase:

enter image description here

Solution

  • Try to force date format using DATE_FORMAT/TIME_FORMAT in the output fields list:

    DATE_FORMAT(started, '%Y-%m-%d %H:%i:%s') as started,
TIME_FORMAT(testDuration, '%H:%i:%s') as testDuration