Problem with timezone in query console
My host server reports using PST/PDT as the timezone and I have a line in my postgresql.conf file setting:
timezone = ‘US/Pacific’
When I log in to my postgres server using psql and execute ‘show timezone’ it correctly returns ‘US/Pacific’. However, when I connect to a query console using DataGrip in PyCharm ‘show timezone’ returns UTC. I initially did not have any custom settings in my connection properties. I tried explicitly setting the timezone to ‘US/Pacific’ using the ‘Options’ tab, but ‘show timezone’ still returns UTC after reloading the connection.
Please sign in to leave a comment.
Just tested on my machine - working as expected.
See if it helps to force refresh the connection (or simply deactivate and then reconnect).
Strangely, force refreshing did not work, but deactivating and then reconnecting did seem to work. Thanks.