📋Steps in this guide1/1

View timezone info in db

SELECT version FROM v$timezone_file;

oracle configurationintermediate

by OracleDba

12 views

View timezone info in db

Code/Command (click line numbers to comment):

SELECT version FROM v$timezone_file;
SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!