Something strange with Dates display

Get Help
1

Hello,
I have two columns, one is the primary key to my date dimension table (those PKs are generated with the data in them, i.e 1st anuary 2021 is 20210101). They are looked up from a real date column.
The date column is a DATE.
The Primary key is an INT.

Database Snowflake.

Please see in my screenshot, dates are seen at 24:00 and not 00:00 , and the day is wrong, it show the day before.

Would you happen to know what causes this ?

If i do a direct select in the database, i have the right value though.

In Metabase :
image

In DB :
image

2

Hi @eozturk

Post "Diagnostic Info" from Admin > Troubleshooting.
That looks like a timezone issue. But that should not happen on DATE types. Can you post the DDL for the table, so I can try to reproduce?

The 24:00 problem was fixed on 0.39.0.1, but only for new installations. For existing installations, you might have to go and set the time again in Admin > Settings > Localization.

3

hi,

thank you very much for your answer.

Here is an excerpt of the DDL :
This is a SNOWFLAKE database.

create or replace TABLE xxxxxxxx
(
ID_DAY_MEAL_DATE NUMBER (38,0),
ID_DAY_BOOKING_DATE NUMBER (38,0),
DT_DAY_MEAL_DATE DATE ,
DT_DAY_BOOKING_DATE DATE ,
DT_MEAL_UTC TIMESTAMP_NTZ (9),
DT_MEAL_LOCALE TIMESTAMP_NTZ (9),
DT_CREATION_UTC TIMESTAMP_NTZ (9),
DT_CREATION_LOCALE TIMESTAMP_NTZ (9),
);

Troubleshooting info :
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 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": "Europe/Paris"
},
"metabase-info": {
"databases": [
"snowflake"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.8"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"date": "2021-04-08",
"tag": "v0.38.4",
"branch": "release-x.38.x",
"hash": "057b6bb"
},
"settings": {
"report-timezone": null
}
}
}

4

@eozturk Looks like you're seeing this issue - see the comments for possible workaround:
https://github.com/metabase/metabase/issues/8804 - upvote by clicking :+1: on the first post

5

thanks :slight_smile: