Stored Function ASAP.CONVERT_GMT_TO_LOCALDB not Properly Converting GMT to Local Time During DST - Daylight Savings Time

(Doc ID 2322306.1)

Last updated on OCTOBER 28, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.



Why is stored function CONVERT_GMT_TO_LOCALDB not properly converting GMT to Local Time during Daylight Savings Time (DST) ?

It seems it is using an old definition for Summer Time.

Please correctly handle each different daylight savings time period:

Start and end dates:

before 2007:

After 2007:


Maybe it is a relic that time forgot, but it is not Customer code.

Per documentation and SR search:




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