Hi, dear Community!
I have such a case:
Postgres default time zone UTC, my reporting field is
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
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.
I have a mix of records from 21 Oct and 22 Oct.
Help me with the proper settings, please…