KNOWLEDGE BASE

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:
  • 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. 

Cause

This behavior is by design -- When the data contains time zone information, the data is resolved in such time zone.
Did this article resolve the issue?