English
  • PowerCenter 10.1.1 HotFix 1
  • All Products

Table of Contents

Search

  1. Version 10.1.1
  2. Version 10.1
  3. Version 10.0
  4. Version 9.6.1
  5. Version 9.6.0

Release Guide

Release Guide

Back Next

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
.