Loading

Date and Time Field Displayed in Local Time Instead of UTC

Udgivelsesdato: 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. 
Vidensartikelnummer

001474920

Vedhæftede filer

PostgreSQL_JDBC_BIND_TIMESTAMPTZ_no.tdc

0 KB

 
Indlæser
Salesforce Help | Article