Loading

Date and Time Field Displayed in Local Time Instead of UTC

Publiseringsdato: Feb 21, 2025
Beskrivelse

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

Cause

This behavior is by design -- When the data contains time zone information, the data is resolved in such time zone.
Løsning
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 Cloud)
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. 
Knowledge-artikkelnummer

001474920

Vedlegg

PostgreSQL_JDBC_BIND_TIMESTAMPTZ_no.tdc

0 KB

 
Laster
Salesforce Help | Article