Standard Function UTC.GET_LOCAL_DATE Gives Incorrect Offset For Turkey
(Doc ID 2358829.1)
Last updated on JULY 20, 2024
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
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
Symptoms |
Cause |
Solution |
References |