Last Modified Date: 27 Feb 2017
- Tableau Desktop
ResolutionUse 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)
CauseTableau 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
Training and Tutorials