Hello,
We recently upgraded our Metabase instance from v0.43.7.1 to v0.46.2 and have encountered an issue with the reporting timezone for date field filters. Despite setting the report timezone to "Asia/Tokyo", it appears that the date field filter is not adhering to this setting. Instead, it seems to be querying in UTC time.
This issue was not present in versions v43 and v45, where queries were correctly using the set timezone. The problem seems to have emerged starting from v46.
We use mongodb mainly.
Here are the details of our setup:
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.19+7-LTS",
"java.vendor": "Red Hat, Inc.",
"java.vendor.url": "https://www.redhat.com/",
"java.version": "11.0.19",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.19+7-LTS",
"os.name": "Linux",
"os.version": "3.10.0-862.11.6.el7.x86_64",
"user.language": "en",
"user.timezone": "Asia/Tokyo"
},
"metabase-info": {
"databases": [
"h2",
"mongo",
"mysql"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.18-log"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.6"
}
},
"run-mode": "prod",
"version": {
"date": "2023-04-28",
"tag": "v0.46.2",
"branch": "release-x.46.x",
"hash": "8967c94"
},
"settings": {
"report-timezone": "Asia/Tokyo"
}
}
}
We would greatly appreciate any assistance or guidance on how to resolve this problem. Thank you in advance for your help.
Best regards,