Standard Function UTC.GET_LOCAL_DATE Gives Incorrect Offset For Turkey

(Doc ID 2358829.1)

Last updated on FEBRUARY 09, 2018

Applies to:

Oracle Transportation Management - Version 6.4.1 to 6.4.2 [Release 6.4]
Information in this document applies to any platform.

Symptoms

Turkey is not using DST anymore (since late 2016) and it's on ST which makes its zone offset time 3 hours

The client runs, select sysdate,utc.get_offset('2017', '11', '08', '08', '00', '00', 'Asia/Istanbul') TURKEY_OFFSET,utc.get_offset('2017', '11', '08', '08', '00', '00', 'Europe/Rome') ITALY_OFFSET from dual;

obtains the following results:

ITALY_OFFSET = 1 --> CORRECT
TURKEY_OFFSET = 2 --> NOT CORRECT

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms