DBeaver timezone

DBeaver (6.3.0), or possibly the JDBC driver it uses, does not set the user's timezone correctly in Redshift. This can be confirmed by issuing the query:

SHOW timezone;

To set the timezone, e.g. to Eastern Time:

SET timezone='US/Eastern';

To view a list of valid timezone names that can be used with the SET timezone command:

SELECT pg_timezone_names();

Setting the timezone using SET timezone only affects the current session. To run this command every time a new session begins, use Edit Connection in DBeaver to modify the connection parameters. Under Connection settings > Initialization > Connection > Bootstrap queries, select Configure. Then select Add and enter the SET timezone = . . . ; command with your timezone.