Table of Contents

Search

  1. Preface
  2. Part 1: 10.2
  3. Part 2: Version 10.1.1
  4. Part 3: Version 10.1
  5. Part 4: Version 10.0
  6. Part 5: Version 9.6.1
  7. Part 6: Version 9.6.0

Timestamp with Time Zone

Timestamp with Time Zone

Effective in version 10.0, most transformations support the Timestamp with Time Zone data type. Timestamp with Time Zone is a variant of the Timestamp data type that includes a time zone offset or time zone region name.
When you import the Timestamp with Time Zone data type into the Developer tool, the associated transformation data type is timestampWithTZ. timestampWithTZ has a precision of 36 and a scale of 9. Timestamp with Time Zone displacement value range is from -12:00 < UTC < +14:00.
For more information, see the "Data Type Reference" appendix in the
Informatica 10.0 Developer Tool Guide
.


Updated August 28, 2020