[
https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17236844#comment-17236844
]
Larry Melvin Lemons commented on DERBY-7091:
--------------------------------------------
OK. In your reply above, Anurag Shekhar is incorrect. 02:00 DOES exist on
that date. It is true that DST, or Summer Time as you called it, does start at
that time for most of the world, however not everywhere in the world. UTC does
not have DST, nor does Arizona and Hawaii, and there are many other places in
the world that do not start DST on that date or any other date. Some places
start and end DST at a different time than we do in the US, the UK, for
example, on March 29th this year, not March 8th.
https://www.livescience.com/56048-daylight-saving-time-guide.html#:~:text=Most%20of%20the%20United%20States,follow%20DST%2C%20according%20to%20NASA.
Why is it displaying line 2 as 03:00 instead of 02:00 and 3 as 03:48 instead of
02:48 (below) from the script/output you posted if it isn't changing the times,
or if it isn't actually changing the times and is just displaying the times in
whatever timezone you have Java set to then why doesn't it display line 4
(below) as 04:00 instead of 03:00?
1 |NULL |2017-03-12 01:48:00.000 |2017-03-12 01:48:00.0
{color:#FF0000}2 |odd |2017-03-12 02:00:00.000 |2017-03-12 03:00:00.0 {color}
{color:#FF0000}3 |odd |2017-03-12 02:48:00.000 |2017-03-12 03:48:00.0{color}
4 |NULL |2017-03-12 03:00:00.000 |2017-03-12 03:00:00.0
So, if this is some setting somewhere that causes Derby to add an hour the hour
that DST starts, how and where do I change that so that it doesn't add an hour?
> 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)
