Product: TIBCO Spotfire®
Values in a column of type 'Timestamp with timezone' are different from original values when imported through Information Links
When using Information Links to import data, the values in the columns of type 'Timestamp with Timezone' might differ from the actual values of the data sources. This is a list of a few example databases and the corresponding column data types which involve time zones:
- PostgreSQL: TIMESTAMPTZ, TIMETZ, TIMESTAMP WITH TIMEZONE
- Snowflake: TIMESTAMP_TZ
- Oracle: TIMESTAMP WITH TIME ZONE
Assuming a PostgreSQL database server has a timezone of UTC and the TIBCO Spotfire Server machine has a timezone "US/Pacific". If in the original column in the database, the value is '2019-02-28 15.30.30.00 000' then the value you will see in Spotfire when imported through Information Links will be of UTC-8 type. So the exact value seen in this situation will be '2019-02-28 07:30:30.00'.