Check timezone version and property in Oracle

Check timezone version and property in Oracle

Check the timezone version in Oracle

SELECT version FROM v$timezone_file;


VERSION
----------
31

Check the Database properties related to timezone

col property_name for a25
SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY PROPERTY_NAME;

PROPERTY_NAME             VALUE
------------------------- ----------
DST_PRIMARY_TT_VERSION    31
DST_SECONDARY_TT_VERSION  0
DST_UPGRADE_STATE         NONE

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.