Hello guys,
my filter datetime return +1day on result
Can someone help me ?
Hi @cesarvipe
- Post "Diagnostic Info" from Admin > Troubleshooting
- Post which database type you're querying
- Post the actual database column type
Hi @flamber
- Post which database type you're querying
Using SQL Server - Post the actual database column type
Is Date
- Post "Diagnostic Info" from Admin > Troubleshooting
{
"browser-info": {
"language": "pt-BR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "1.8.0_261-b12",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_261",
"java.vm.name": "Java HotSpot(TM) Client VM",
"java.vm.version": "25.261-b12",
"os.name": "Windows Server 2016",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "America/Sao_Paulo"
},
"metabase-info": {
"databases": [
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.9"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.8"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.37.5",
"date": "2021-01-05",
"branch": "release-x.37.x",
"hash": "be537ee"
},
"settings": {
"report-timezone": null
}
}
}
So it's a SQL question that you are using as a Saved Question?
Have you tried set the Report Timezone? Admin > Settings > Localization (or General in older versions)
You should upgrade Metabase: https://github.com/metabase/metabase/releases/latest
Upgrade to Java 11: https://www.metabase.com/docs/latest/operations-guide/java-versions.html
So it's a SQL question that you are using as a Saved Question?
Yes, its a saved Question
Have you tried set the Report Timezone? Admin > Settings > Localization (or General in older versions)
Yes, i set TimeZone America/São Paulo
I upgrade Metabase to last version and Java to version 11.
The problem persists even after the update
New Diagnostic Info
{
"browser-info": {
"language": "pt-BR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"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": "Windows Server 2016",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "America/Sao_Paulo"
},
"metabase-info": {
"databases": [
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.9"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2021-12-16",
"tag": "v0.41.5",
"branch": "release-x.41.x",
"hash": "fbfffc6"
},
"settings": {
"report-timezone": "America/Sao_Paulo"
}
}
}
@cesarvipe I think you're seeing a strange combination of this issue:
https://github.com/metabase/metabase/issues/10824 - upvote by clicking 
on the first post
And then timezones are applied twice - once for SQL and another for GUI.
I cannot tell which database column type E1_VENCREA is, nor which timezones you're applying through your systems, but timezones are complicated:
https://www.metabase.com/docs/latest/troubleshooting-guide/timezones.html
