[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17233816#comment-17233816 ]
Richard N. Hillegas commented on DERBY-7091: -------------------------------------------- In a derby-dev email thread titled "[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring", Anurag Shekhar points out that summer time kicked in at 2017-03-12 02:00:00. That is the exact moment when the clocks jumped forward. Technically, 2017-03-12 02:00:00 and 2017-03-12 02:48:00.000 are non-existent times. The standard notation for those instants are 2017-03-12 03:00:00.000 and 2017-03-12 03:48:00.000 respectively: http://apache-database.10148.n7.nabble.com/jira-Commented-DERBY-7091-Times-Inserted-Incorrectly-Around-Daylight-Savings-Time-Change-in-Spring-td151535.html Hope this makes sense, -Rick > Times Inserted Incorrectly Around Daylight Savings Time Change in Spring > ------------------------------------------------------------------------ > > Key: DERBY-7091 > URL: https://issues.apache.org/jira/browse/DERBY-7091 > Project: Derby > Issue Type: Bug > Affects Versions: 10.14.2.0 > Environment: Java 14.0.1 > Reporter: Larry Melvin Lemons > Priority: Critical > Attachments: Test.java, Timezone_Data_Inconsistencies.odt > > > 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. -- This message was sent by Atlassian Jira (v8.3.4#803005)