Note about using DBeaver to connect to Amazon Redshift:
When DBeaver connects to Amazon Redshift, the default settings may result in reports that use the UTC timezone for any timestamp and date fields. If you want to force the reports to display times in your local timezone, you can follow these steps to adda "SET timezone" command to your connection:
- Open a new SQL editor window
- Submit the following query to confirm that the current timezone is UTC:
SHOW timezone; - Submit the following query to identify the correct name for your current timezone:
SELECT pg_timezone_names(); - To set the timezone every time you connect to Redshift:
- Right-click on the Redshift connection and select "Edit Connection"
- Under "Connection settings > Initialization > Connection > Bootstrap queries", select "Configure".
- Select "Add" and enter the "SET timezone = . . . ;" command with your timezone. For example, if you are in the Eastern timezone, your command would be:
SET timezone='US/Eastern';
