Hello,
We have a table where one field is a date (java.util.date). This date is saved in DB (Postgres) as timestamp without time zone. There is a filter by date on a page with the table.
There is a problem when a user changes their time zone in Help->Settings. New time zone is not applied when we filter by the date (select values from DB).
For example, there is a record in the table with “2022-10-04 07:12:17.372” date (saved in UTC). A user changes the time zone to "GMT-0.8:00 and selects “04/10/2022” in the filter. As a result, the table contains the record with “03/10/2022 23:12” date.
Could you please clarify how the table can be filtered by date applying the user’s time zone?
Thanks.