DST

I am presenting here the some of the good queries on timezone settings how to check timezone version in oracle database/how to check dst patch in oracle SQL> select * from v$timezone_file; FILENAME VERSION ———— ———- timezlrg.dat 4 or SELECT tz_version FROM registry$database; or COLUMN property_name FORMAT A30 COLUMN property_value FORMAT A20 SELECT property_name, property_value […]