Timezone Issue data as UTC in Database


All timestamps are stored as UTC but whatever i set as timezone in Metabase the data is always displaying as the UTC timestamp from my database.

I am also passing JAVA_TIMEZONE=Europe/London in Docker Compose for the metabase container.
Any ideas?

“browser-info”: {
“language”: “en-GB”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36”,
“vendor”: “Google Inc.”
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.8+10”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.8”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.8+10”,
“os.name”: “Linux”,
“os.version”: “5.4.0-42-generic”,
“user.language”: “en”,
“user.timezone”: “Europe/London”
“metabase-info”: {
“databases”: [
“hosting-env”: “unknown”,
“application-database”: “mysql”,
“application-database-details”: {
“database”: {
“name”: “MariaDB”,
“version”: “10.3.22-MariaDB-1ubuntu1”
“jdbc-driver”: {
“name”: “MariaDB Connector/J”,
“version”: “2.6.2”
“run-mode”: “prod”,
“version”: {
“date”: “2020-09-15”,
“tag”: “v0.36.6”,
“branch”: “release-0.36.x”,
“hash”: “cb258fb”
“settings”: {
“report-timezone”: “UTC”

Hi @dazzer78
Timezones are some of the most difficult issues to debug - would need a lot more information to figure out what is going on:
But you have set the Admin > Settings > General > Reporting Timezone to UTC, so it would show as UTC.
I’m not sure which timezone you’re trying to show as.