A new datatype, a timestamp with timezone format (timestamp_tz_format), normalizes the data value returned to the timezone of DirectConnect for Oracle. The new 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-CIS client and the timestamp_tz_format was changed, the new format is used.
If the client is a non-CIS client and the timestamp_tz_format was not changed, the default format is used.
If the client is a 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 timestamp_tz_format datatype, the create proxy_table command will map the column to a char (64). If the create existing table command is used, a char (64) must be specified for the column representing the timestamp_tz_format.
The two configuration property settings, date_format and timestamp_format, are reserved for all DirectConnect for Oracle client connections in passthrough mode such as, isql, which excludes ASE/CIS clients.
