English
  • PowerCenter 10.1.1 HotFix 2
  • 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 Local Time Zone

Timestamp with Local Time Zone

Effective in version 10.0, Timestamp with Local Time Zone data type is another variant of the Timestamp data where the time zone data is normalized to the database time zone.
When you import the Timestamp with Local Time Zone data type into the Developer tool, the associated transformation data type is date/time. The Timestamp with Local Time Zone data type is implicitly supported by most transformations as the functionality is equivalent to Timestamp.
Timestamp (6) with Local Time Zone has a precision of 26 and a scale of 6. It is mapped to the date/time (29,9) transformation data type.
For more information, see the "Data Type Reference" appendix in the
Informatica 10.0 Developer Tool Guide
.