SQL Query to Get Oracle DB TIMEZONE details

_____________________________________________________________________________________________________________________

In this post I am adding some useful sql query to find out the oracle database TIMEZONE details.
SQL> SELECT version FROM v$timezone_file;

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

SQL> SELECT DBTIMEZONE FROM DUAL;

DBTIME
------
+00:00


SQL> col PROPERTY_NAME for a40
SQL> col value for a20
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

_____________________________________________________________________________________________________________________

0 comments:

Post a comment

 

acehints.com Copyright 2011-20 All Rights Reserved | Site Map | Contact | Disclaimer