[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-12-01 Thread Richard N. Hillegas (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17241642#comment-17241642 ] Richard N. Hillegas commented on DERBY-7091: Glad that you found a workaround. Thanks for

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-30 Thread Larry Melvin Lemons (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17241150#comment-17241150 ] Larry Melvin Lemons commented on DERBY-7091: Well I found a work around.  Shut down the

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-22 Thread Richard N. Hillegas (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17236964#comment-17236964 ] Richard N. Hillegas commented on DERBY-7091: Parsing and formatting of timestamps is handled

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-21 Thread Larry Melvin Lemons (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17236844#comment-17236844 ] Larry Melvin Lemons commented on DERBY-7091: OK.  In your reply above, Anurag Shekhar is

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-21 Thread Richard N. Hillegas (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17236772#comment-17236772 ] Richard N. Hillegas commented on DERBY-7091: Derby does not manipulate timestamp values.

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-20 Thread Larry Melvin Lemons (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17236601#comment-17236601 ] Larry Melvin Lemons commented on DERBY-7091: But that makes querying the database for a

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-19 Thread Richard N. Hillegas (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17235574#comment-17235574 ] Richard N. Hillegas commented on DERBY-7091: Thanks for that explanation of the problem you

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-18 Thread Larry Melvin Lemons (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17235064#comment-17235064 ] Larry Melvin Lemons commented on DERBY-7091: And yet it doesn't say anything about it

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-18 Thread Richard N. Hillegas (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17234993#comment-17234993 ] Richard N. Hillegas commented on DERBY-7091: The SQL Standard TIMESTAMP type does not include

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-18 Thread Larry Melvin Lemons (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17234906#comment-17234906 ] Larry Melvin Lemons commented on DERBY-7091: Unfortunately it doesn't for ALL timezones, only

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-18 Thread Larry Melvin Lemons (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17234806#comment-17234806 ] Larry Melvin Lemons commented on DERBY-7091: Then how do you represent UTC times in the

Re: [jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-17 Thread Rick Hillegas
On 11/16/20 10:41 PM, Anurag Shekhar wrote: 2017-03-12 02:48:00.000 Thanks for pointing that out, Anurag!

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-17 Thread Richard N. Hillegas (Jira)
:48:00.000 are non-existent times. The standard notation for those instants are 2017-03-12 03:00:00.000 and 2017-03-12 03:48:00.000 respectively: http://apache-database.10148.n7.nabble.com/jira-Commented-DERBY-7091-Times-Inserted-Incorrectly-Around-Daylight-Savings-Time-Change-in-Spring-td151535.

Re: [jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-16 Thread Anurag Shekhar
Hi ij> SELECT * FROM t ORDER BY key_col; KEY_COL|DESC_COL |TS_STRING |TS --- 1 |NULL |2017-03-12 01:48:00.000

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-16 Thread Larry Melvin Lemons (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17232951#comment-17232951 ] Larry Melvin Lemons commented on DERBY-7091: I added a simple program that demonstrates the

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-14 Thread Richard N. Hillegas (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17232170#comment-17232170 ] Richard N. Hillegas commented on DERBY-7091: Thanks for logging this odd behavior. The

[jira] [Commented] (DERBY-7091) Times Inserted Incorrectly Around Daylight Savings Time Change in Spring

2020-11-14 Thread Bryan Pendleton (Jira)
[ https://issues.apache.org/jira/browse/DERBY-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17232159#comment-17232159 ] Bryan Pendleton commented on DERBY-7091: Can you attach a simple program that demonstrates the