Testing your Oracle JVM Time Zone Setup
(Doc ID 416860.1)
Last updated on JULY 29, 2022
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Standard Edition - Version 18.104.22.168 and later
Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
This document provides a Java Stored Procedure (and wrappers) that can be used for 2 purposes when applying Oracle JVM (OJVM) Time Zone patches. The procedure can be used during the process of deciding whether a OJVM is functional, or it can be used to check if the patch was applied correctly.
It cannot help you in estimating if the OJVM timezone data is actually used.
There are several updates to the Oracle JVM time zone data available from Oracle, an overview is in <Note 412160.1> Updated Time Zones in Oracle Time Zone File patches
The procedure provided in this note can be used to tests the existence of these OJVM updates in the Oracle database and what OJVM DST version is installed.
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
|Starting with Oracle Database 12.2, the following code should return the IANA database version installed in the OJVM:|
|Testing the OJVM before applying time zone updates|
|Testing the OJVM after time zone updates have been applied|