Hello EveryOne,
We want to Create our Questions and set Time Zone in Tehran.
But When we Create our Questions Time Zone Does Not Work, and when we Enable or Disable Our Time Zone in Tehran, It has no difference in the time of our Questions.
As it is very important to our questions that work with our Time Zone, Could you please Give me Some Approach to Solve this problem? Thanks.
Let me also point out that our Databases are PostgreSQL.
Hi,
Post your "Diagnostic Info" from Admin > Troubleshooting.
Post a sample of your database dates and same data in Question results
@trialsin
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15",
"vendor": "Apple Computer, Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.13+8",
"os.name": "Linux",
"os.version": "5.4.0-97-generic",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"googleanalytics",
"sqlserver",
"postgres"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2022-01-10",
"tag": "v0.41.6",
"branch": "release-x.41.x",
"hash": "296635f"
},
"settings": {
"report-timezone": "Asia/Tehran"
}
}
}
Read this: https://www.metabase.com/docs/latest/troubleshooting-guide/timezones.html
Without knowing your actual database column type, then it's difficult to tell.
I'm guessing that it's actually columns without timezone information, which Metabase does not handle currently:
https://github.com/metabase/metabase/issues/6259 - upvote by clicking on the first post
And you should migrate away from H2 if you are using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
Hi, our Date column (in PostgreSQL DB) hasn't Time Zone ; Is there any way to apply changes in Metabase Time Zone Settings?
You would have to either use SQL and convert your columns to the correct timezones, or use a database View to do the conversion for all your tables.