TIMESTAMP WITH TIME ZONE Type Mapping

TimesTen does not support the TIMESTAMP WITH TIME ZONE data type. As a result, it is not possible to import columns of this type into TimesTen.

The import process maps TIMESTAMP WITH TIME ZONE columns to the TIMESTAMP data type in TimesTen. As a result, the associated time zone information is lost when the data is loaded.

Type mapping is applied to Oracle database columns of type TIMESTAMP WITH TIME ZONE and is controlled by the tstz field in the –typeMap command line option.

The tstz field accepts any one of the following values:

Values	Description
0	No mapping; TIMESTAMP WITH TIME ZONE columns are unsupported data type. The columns does not appear in the TimesTen tables.
1	This is the default value. TIMESTAMP WITH TIME ZONE columns are mapped to TIMESTAMP in TimesTen. When data is loaded into these columns the timezone information is discarded.