DataGrip date-time display and session time zone synchronization
0 reputation · 01 Sept 2024, 16:02 UTC
Time Zone Configuration in Data Source Properties
DataGrip manages the representation of TIMESTAMP and DATETIME types through a combination of global IDE preferences and specific Data Source properties. While the IDE allows users to toggle between system local time and UTC, the interaction between these settings and the database server's own session offset can create discrepancies in the result grid.
The goal is to ensure that date-time values are displayed according to the server's regional settings without the IDE's internal time zone preference overriding the returned offset. This is particularly relevant when using custom 'Data Formats' patterns to standardize display across different regional database instances.
Which configuration priority ensures the database server's session offset takes precedence over the IDE's global time zone setting?
Are there specific driver-level parameters required to prevent the IDE from automatically converting these values in the Value Editor panel?
datagrip