Hi, dear Community!
I have such a case:
-
Postgres default time zone UTC, my reporting field is
created_on
:
…
created_on timestamp with time zone not null,
… -
OS time zone on the DB instance: UTC
-
Metabase OS instance time zone: Asia/Hong_Kong
-
Metabase reporting time zone setting: Asia/Hong_Kong
-
Metabase user location: Ukraine, OS MacOS, timezone: Europe/Kiev
Case example:
Now() in Europe/Kiev 21 Oct 23:00
Now() it Asia/Hong_Kong 22 Oct 04:00
I want to select the date in calendar widget, mode on
: 22 Oct and get only records from 22 Oct in Asia/Hong_Kong timezone.
Result:
I have a mix of records from 21 Oct and 22 Oct.
Help me with the proper settings, please…