My Oracle Support Banner

Cannot Save Service Request If Any Date Is The Hour Of Dst Changes - Illegal Local Time Error Occurs Or The Labor Debrief Times Are Not Saved Correctly (Doc ID 1585216.1)

Last updated on FEBRUARY 06, 2022

Applies to:

Oracle Customer Support - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Create Service Request

When attempting to enter a time between the hour where the DST (Daylight Savings Time) changes began,
the following error occurs.


java.sql.SQLException: Illegal local time

Steps to Reproduce

The issue can be reproduced at will with the following steps:

1. Change the time zone to (GMT +03:00 Athens) in Preferences
    DST began on 31-Mar-2013 at 3:00:00 am, and will end on 27-Oct-2013 at 4:00:00 am.

2. Input ‘31/03/2013 03:45:11’ in Incident Date.

3. Save, the below error would occur:
    java.sql.SQLException: Illegal local time

Note: At times, when the Labor debrief is saved with the Scheduled Start and Scheduled End dates... These date times are not getting converted in the Client Timezone... They are saved as is. This is incorrect, the Times should be converted and saved in Server Timezone in the Database and when again re-queried the same should be converted based upon the client timezone and displayed back to the UI.




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

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