skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The Oracle Wire Protocol Driver : Connection Option Descriptions : Enable Timestamp with Timezone
  
Enable Timestamp with Timezone
Attribute
EnableTimestampwithTimezone (ETWT)
Purpose
Determines whether the driver exposes timestamps with timezones to the application.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), the driver exposes timestamps with timezones to the application. The driver issues an ALTER SESSION at connection time to modify NLS_TIMESTAMP_TZ_FORMAT. NLS_TIMESTAMP_TZ_FORMAT is changed to the ODBC definition of a timestamp literal with the addition of the timezone literal: 'YYYY-MM-DD HH24:MI:SSXFF TZR'.
If set to 0 (Disabled), timestamps with timezones are not exposed to the application.
Default
0 (Disabled)
GUI Tab
Advanced tab