Different results for date vs date(timestamp) field type : "Previous Week, starting 1 week ago"

[blue_badger]

When using the date filter on our "date" field, which has the Field Type "Creation date", the GUI indicates the correct date range (7 days from August 14th, to August 20th), but the results include an extra day (August 21st).

Which gives:

However using "session_created_at" which has the field type "Creation timestamp", gives the correct results:

It looks like the same problem was reported in Relative date filter with "Starting from..." includes 1 day outside the range when used on a date column · Issue #27566 · metabase/metabase · GitHub but was assumed to be similar to a bug which has been fixed.

We're on v 0.46.6.4

Many thanks,
David

[blue_badger]

{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.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.20+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.20",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.20+8",
"os.name": "Linux",
"os.version": "5.4.104+",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"bigquery-cloud-sdk"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.16 (Ubuntu 12.16-0ubuntu0.20.04.1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.1"
}
},
"run-mode": "prod",
"version": {
"date": "2023-07-28",
"tag": "v0.46.6.4",
"branch": "release-x.46.6.x",
"hash": "7c60aca"
},
"settings": {
"report-timezone": "UTC"
}
}
}

[blue_badger]

bumping

[Luiggi]

what's the instance timezone and the server timezone? also, what's the field type?

[blue_badger]

Hi @Luiggi all timezones are UTC and the field type is "Creation timestamp"

[blue_badger]

Hi @Luiggi , just wondering if this is on your radar? Thanks

[Luiggi]

thanks, what's the field type at the database level?