OracleDate/Time FunctionsTZ_OFFSET
FROM_TZ

TZ_OFFSETDate/Time Functions

NUMTODSINTERVAL

Returns the UTC offset of a time zone.

Syntax

TZ_OFFSET(tz_name)

Example

Enter values below to update the example in real time.

kr_offset
SELECT TZ_OFFSET('Asia/Seoul') AS kr_offset FROM DUAL;