[
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, 6:02 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.
>From what I understand the time is inserted without a timezone, so shouldn't
>it be able to represent ALL timezones, not just the ones that use Daylight
>Savings Times?
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, 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.
> 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)
