Date and Time Field Displayed in Local Time Instead of UTC
Published: 07 Apr 2022 Last Modified Date: 07 Apr 2022
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:
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.
Cause
This behavior is by design -- When the data contains time zone information, the data is resolved in such time zone.
Thank you for providing your feedback on the effectiveness of the article.