My Oracle Support Banner

How to Make JDBC 11.2 Use Timezone Offset and Not Named Timezone? (Doc ID 2087294.1)

Last updated on AUGUST 30, 2023

Applies to:

JDBC - Version 11.2.0.4.0 and later
Information in this document applies to any platform.

Goal

JDBC 11.2 sets the time_zone in a different way from how JDBC 11.1 sets it. JDBC 11.2 uses named time_zone like 'America/Chicago' whereas 11.1 JDBC drivers uses offset like time_zone='-6:00'.
How to make JDBC 11.2 use timezone offset and not named timezone?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.