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