Last Modified Date: 05 Oct 2017
- Tableau Desktop
- EMC Greenplum
- Live connection
Option 1:Include the DATEADD() function in the calculated field formula to account for the time zone offset. For example, to convert UTC to PST (Pacific Standard Time) the formula for the calculated field is: DATEADD('hour', -7, NOW())
Option 2:Use an extract. For more information, see Extract Your Data.
CauseLive connections to Greenplum and PostgreSQL are designed to return UTC time due to inconsistencies in how these datasources handle datetime and time zone offsets.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials