Hello,
i'm having trouble with date period filters. Upon chosing from november 1st to november 30th, i get results from november 4th to november 29th. There is data for november 1st but its not being considered. We are using Oracle Database and the date collum in this case is like "date, 00:00" for all entries.
I tried changing the timezone and hour format settings but the problem persists. We are running Metabase from the docker container.
Debug info:
{
"browser-info": {
"language": "pt-BR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:133.0) Gecko/20100101 Firefox/133.0",
"vendor": ""
},
"metabase-info": {
"databases": [
"sqlserver",
"oracle",
"h2"
],
"run-mode": "prod",
"plan-alias": "",
"version": {
"date": "2024-12-09",
"tag": "v0.52.2",
"hash": "32effb1"
},
"settings": {
"report-timezone": "America/Sao_Paulo"
},
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "15.3 (Debian 15.3-1.pgdg120+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.7.3"
}
}
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "21.0.5+11-LTS",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "21.0.5",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "21.0.5+11-LTS",
"os.name": "Linux",
"os.version": "6.1.119-129.201.amzn2023.x86_64",
"user.language": "en",
"user.timezone": "GMT"
}
}
Thanks in advance.