Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-7091

Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 10.14.2.0
    • Fix Version/s: None
    • Component/s: Services, SQL
    • Labels:
      None
    • Environment:
      Java 14.0.1
    • Bug behavior facts:
      Seen in production

      Description

      When inserting date/times into the timestamp field around the daylight savings time change in the Spring, the times are inconsistent.  I am in/use the New York EST/EDT timezone, but the data I am inserting is Standard time and not Daylight Savings Time

      All the times are correct up to 1:48AM, then when it inserts 2:00 AM the data in the database is 3:00AM.  That could be alright if it kept switching the time to Daylight Savings Time, however going from inserting 2:48AM and getting 3:48AM in the database, when it inserts 3:00AM it shows 3:00AM in the database, not the expected 4:00AM.  Then in the fall whatever is inserted in the database is what shows in the database around the daylight savings time switch to standard time.  See the attached Open Document Text file for examples of what is actually inserted and what is showing in the database.

        Attachments

        1. Test.java
          10 kB
          Larry Melvin Lemons
        2. Timezone_Data_Inconsistencies.odt
          21 kB
          Larry Melvin Lemons

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              llemons Larry Melvin Lemons
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: