Timestamp with Local Time Zone is a variant of the Timestamp data type where the timestamp data is normalized to the database time zone. The time zone displacement is not part of the column data. When the Data Integration Service reads the data, Oracle returns the data in the time zone of the Data Integration Service.
When you import the Timestamp with Local Time Zone data type into the Developer tool, the associated transformation data type is date/time.
For example, '04-APR-10 10.27.451 AM'
Timestamp (9) with Local Time Zone has a precision of 29 and a scale of 9. It is mapped to the date/time (29,9) transformation data type.
To set the default session time zone when the Data Integration Service reads or writes the Timestamp with Local Time Zone data, specify the ORA_SDTZ environment variable. You can set the ORA_SDTZ environment variable to any of the following values:
Operating system local time zone ('OS_TZ')
Database time zone ('DB_TZ')
Absolute offset from UTC (for example, '-05:00')
Time zone region name (for example, 'America/Los_Angeles')