The timestamp with timezone format (timestamp_tz_format), normalizes the data value returned to the timezone of ECDA Option for Oracle. The timestamp_tz_format default value is "MON DD YYYY HH:MI:SS.FFAM TZH:TZM" and is independent of the timestamp millisecond support configuration parameter.
The Oracle timestamp_tz_format is sent back to the client as a character string, and is formatted depending on the following:
If the client is a non-ASE/CIS client and the timestamp_tz_format was changed, the new format is used.
If the client is a non-ASE/CIS client and the timestamp_tz_format was not changed, the default format is used.
If the client is an ASE/CIS client, the character string is returned using the default format.
In CIS, to map a proxy_table to an existing Oracle table that contains a column with the ttimestamp_tz_format datatype, the create proxy_table command will map the column to a char (64) and if the create existing table command is used, a char (64) must be specified for the column representing the ttimestamp_tz_format.