Why is Oracle's TZ_OFFSET wrong for all cities on only one server?

1 vote

1 answer

210 views

                          Why does Oracle think that the timezone offset of Denver is UTC-7:00?
The server time and systimestamp look right.


**Server 1: Oracle 11.2.0.4.0**


    SELECT SESSIONTIMEZONE FROM DUAL;
        America/Denver

    cat /etc/sysconfig/clock
    	ZONE="America/Denver"
    
    SELECT * FROM v$timezone_file;
    	timezlrg_14.dat	14
    
    SELECT systimestamp FROM dual;
    	29-JUN-21 01.29.21.546036000 PM -06:00
    
    SELECT tzabbrev, SUBSTR(tz_offset(tzname), 1, 6), tzname FROM v$timezone_names tz WHERE tzname = 'America/Denver';
    LMT	-06:00	America/Denver
    MST	-06:00	America/Denver
    MDT	-06:00	America/Denver
    MWT	-06:00	America/Denver
    MPT	-06:00	America/Denver


**Server 2: Oracle 11.1.0.6.0**

    SELECT SESSIONTIMEZONE FROM DUAL;
        America/Denver

    cat /etc/sysconfig/clock
    ZONE="America/Denver"
    UTC=false
    ARC=false

    SELECT * FROM v$timezone_file;
    	timezlrg.dat	4

    SELECT tzabbrev, SUBSTR(tz_offset(tzname), 1, 6), tzname FROM v$timezone_names tz WHERE tzname = 'America/Denver';
    LMT	-07:00	America/Denver
    MST	-07:00	America/Denver
    MWT	-07:00	America/Denver
    MDT	-07:00	America/Denver

                        

Asked by Charles Burns (251 rep)

Jun 29, 2021, 07:52 PM
Last activity: Jul 2, 2021, 06:51 AM

Why is Oracle's TZ_OFFSET wrong for all cities on only one server?

Related Questions