This content has been marked as final. Show 6 replies
determine the time zone under which a database was operating
select DBTIMEZONE from dual;
SELECT CURRENT_TIMESTAMP FROM dual;
SELECT systimestamp FROM dual;
select c.owner || '.' || c.table_name || '(' || c.column_name || ') -'
|| c.data_type || ' ' col
from dba_tab_cols c, dba_objects o
where c.data_type like '%WITH TIME ZONE'
and c.table_name = o.object_name
and o.object_type = 'TABLE'
order by col
and also do check
SELECT TZ_OFFSET('US/Pacific') FROM DUAL;
Just to clarify, I'm looking to identify the time zone FILE that a db is using, not which time zone the db is located in. The answer will be either "timezlrg.dat" or "timezone.dat".
$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat ---contains All the time zone names
$ORACLE_HOME/oracore/zoneinfo/timezone.dat --contains Only the most commonly used time zone names
refer the link, it will be useful and helpful , what you searching for.
select * from v$timezone_file; FILENAME VERSION ------------ ---------------------- timezlrg.dat 4
Thanks Bob. That did the trick.