[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17234806#comment-17234806 ]
Larry Melvin Lemons edited comment on DERBY-7091 at 11/18/20, 5:38 PM: ----------------------------------------------------------------------- Then how do you represent UTC times in the timestamp columns? There is no daylight savings times in UTC, so there is a 2:00AM on 03/12/2017, so how do you enter 2017-03-12 02:00:00.000 for UTC? Also the few locations that do not use Daylight Savings Time (US Arizona and US Hawaii to name two) do have a 2:00AM on 03/12/2017, so how do you represent 2017-03-12 02:00:00.000 for those timezones? Changing it from 2:00AM, which would be a valid time in those timezones does NOT represent the correct times. It isn't 3:00AM there at that time, it is still 2:00AM, and when 3:00AM does roll around it adds another 3:00AM. was (Author: llemons): Then how do you represent UTC times in the timestamp columns? There is no daylight savings times in UTC, so there is a 2:00AM on 03/12/2017. Also the few locations that do not use Daylight Savings Time (US Arizona and US Hawaii to name two) do have a 2:00AM on 03/12/2017. How do you represent those timestamps? Changing it from 2:00AM, which would be a valid time in those timezones does NOT represent the correct times. > 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)