Unix timestamp AM/PM issue [solved]

Hi All,

I have an issue with Unix timestamp in second, 1488475191->Thu, 02 Mar 2017 17:19:51Z in UTC,
but metabase shows the time as Thu, 02 Mar 2017 5:19 AM, which does not correspond to UTC or the local timezone.

Could that be an AM/PM issue , anyway to show the time in 24 hour format ?


Got how the timezone is setup, removing the timezone setting, displayed the correct time. So the db is storing unix time in timezone instead of UTC.