[
https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17241150#comment-17241150
]
Larry Melvin Lemons edited comment on DERBY-7091 at 12/1/20, 12:41 AM:
-----------------------------------------------------------------------
Well I found a work around. I can turn of automatic daylight savings time in
the computer settings and then it inserts as expected. (It doesn't add one hour
during the hour of daylight savings time switch.)
I shouldn't need to do that, and if it were normal behavior it should add one
hour to ALL the times, not just one hour. I would be OK with that as well, but
only adding an hour during the hour of daylight savings time switch and no
other times, that just isn't right.
was (Author: llemons):
Well I found a work around. Shut down the database. Set the timezone on the
computer to UTC time. Start up the database. Do the inserts. Shutting down
the database and setting the server time back to the local timezone and
querying the database will show the correct times. However, if you insert any
more, then the times will be off again, until the database is shut back down
and the server time is reset back to UTC time.
I shouldn't need to do that, but at least there is a work around.
> 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)
