lang::system::timezone_utc_offset (public)

 lang::system::timezone_utc_offset

Defined in packages/acs-lang/tcl/locale-procs.tcl

Returns:

number of hours to subtract from local (database) time to get UTC

Partial Call Graph (max 5 caller/called nodes):

Testcases:

test_timezone_offset

Source code:

    set system_timezone [timezone]
    return [db_string system_utc_offset {}]

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

<fullquery name="lang::system::timezone_utc_offset.system_utc_offset">
    <querytext>
       select cast(
                to_char(
                  current_timestamp at time zone :system_timezone - current_timestamp at time zone 'UTC'
                , 'HH24MI')
              as float) / 100
         from dual
      </querytext>
</fullquery>

packages/acs-lang/tcl/locale-procs.xql