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 2. 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