My Oracle Support Banner

Standard Function UTC.GET_LOCAL_DATE Gives Incorrect Offset For Turkey (Doc ID 2358829.1)

Last updated on NOVEMBER 12, 2019

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.