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