Last Modified Date: 09 Dec 2018
Environment
- Tableau Desktop
- PostgreSQL
Resolution
Use a pass-through function like the one below:RAWSQL_DATETIME("%1 AT TIME ZONE 'PST8PDT'", [TIMESTAMPTZ Field])
You can also create a parameter for the time zone and allow users to select their local time zone, using something like the following:
RAWSQL_DATETIME("%1 AT TIME ZONE %2", [TIMESTAMPTZ Field], [Time Zone Parameter)
Cause
Tableau connections to PostgreSQL prevent the database server from converting timestamps to the client local time zone, since this conversion can lead to inconsistent visualizations for users collaborating from different regions, especially when date/time filters are involved.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials