Date and Time Field Displayed in Local Time Instead of UTC

Issue

Date and time fields are displayed in local or system time, instead of UTC.

Environment

Tableau Desktop
Tableau Server
Tableau Online
PostgreSQL

Resolution

Option 1
Work with your database administrator to change the data type of the affected fields from timestamptz (timestamp with time zone) to timestamp (without time zone).

Option 2 (for Tableau Desktop and Tableau Server)
Remove the PostgreSQL JDBC driver (e.g. postgresql-42.2.14.jar), so the PostgreSQL connector falls back on the ODBC driver.

Option 3 (for Tableau Desktop and Tableau Server)
Apply the TDC file attached to this article. For Tableau Desktop, place the file in Documents\My Tableau Repository/Datasources.

For Tableau Server, place the in this folder for each Server node:

Windows: ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Datasources
Linux: /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources/

Option 4 (for Tableau Online)
If you are connecting to the PostgreSQL database via Tableau Bridge, you can customize the connections by saving the TDC file to Documents\My Tableau Bridge Repository\Datasources.