Metabase Export discrepancy in Timestamp

Get Help
1

Hi there,

I am trying to export data about some orders and I get a difference in the timestamp by exactly one hour as per below, which makes me think that this was not updated somewhere when there was the British Summer Time change earlier this year.

Basically, I get a timestamp 1 hour later on the Metabase question than the timestamp I get when I try to export from the same Metabase question.

image

image
image1557×211 18 KB

Thanks for letting me know what this could be,

2

Hi @ff9991
Post "Diagnostic Info" from Admin > Troubleshooting, and which database you are querying.

3

Hi flamber,

Thanks for that. We are using postgresql.

Here it goes the Diagnostic Info:

{
"browser-info": {
"language": "en-GB",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.10+9",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.10",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.10+9",
"os.name": "Linux",
"os.version": "4.14.209-160.339.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"googleanalytics",
"redshift",
"postgres",
"mongo"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.5"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"date": "2021-03-17",
"tag": "v0.38.2",
"branch": "release-x.38.x",
"hash": "91f0ed6"
},
"settings": {
"report-timezone": "Europe/London"
}
}
}

Thanks!

4

@ff9991 You are likely seeing this issue, which was fixed in 0.38.3:
https://github.com/metabase/metabase/issues/13677