Check the currently installed DST (daylight saving time ) version in Oracle RDBMS

Check the current version of Time zone

SQL> SELECT version FROM v$timezone_file;

   VERSION
----------
        32

SQL> 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    32
DST_SECONDARY_TT_VERSION  0
DST_UPGRADE_STATE         NONE
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply