0

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

Isaac Bennetch
  • 11,830
  • 2
  • 32
  • 43
TheDoctor
  • 2,362
  • 4
  • 22
  • 39

2 Answers2

3

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
TyShkan
  • 46
  • 3
0

Instead of hard coding something, there is a wheel setting button that you can change the format for timing...setting button

and then -->:change time format

Steve Fan
  • 31
  • 5