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