skip to main content
DataDirect Connect Drivers : Oracle Driver : Data Types : Date/Time Session Parameters
  
Date/Time Session Parameters
The following table describes the session parameters the Oracle driver sets at connection time that affect how the driver supports date/time data types.
Table 48. Oracle Date/Time Session Parameters
Session Parameter
Description
TIME_ZONE
The Oracle session time zone. The Oracle driver sets the time zone to the current time zone as reported by the JVM.
NLS_TIMESTAMP_FORMAT
The default timestamp format. The Oracle driver uses the JDBC timestamp escape format:

YYYY-MM_DD HH24:MI:SS.FF
NLS_TIMESTAMP_TZ_FORMAT
The default timestamp with time zone format. The Oracle driver uses the JDBC timestamp escape format with the time zone field appended:

YYYY-MM_DD HH24:MI:SS.FF TZH:TZM
* TIMESTAMP Data Type
* TIMESTAMP WITH LOCAL TIME ZONE Data Type
* TIMESTAMP WITH TIME ZONE Data Type