Standard Function UTC.GET_LOCAL_DATE Gives Incorrect Offset For Turkey
(Doc ID 2358829.1)
Last updated on MAY 06, 2022
Applies to:Oracle Transportation Management - Version 6.4.1 to 6.4.2 [Release 6.4]
Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document