Loading

Date and Time Field Displayed in Local Time Instead of UTC

Дата публикации: Feb 21, 2025
Описание

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.
Решение
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. 
Номер статьи базы знаний

001474920

Вложения

PostgreSQL_JDBC_BIND_TIMESTAMPTZ_no.tdc

0 KB

 
Загрузка
Salesforce Help | Article