Larry Melvin Lemons created DERBY-7091:
------------------------------------------
Summary: 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
Attachments: 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)
