Server doesnt support timestamps with timezone
----------------------------------------------
Key: DERBY-2235
URL: https://issues.apache.org/jira/browse/DERBY-2235
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.2.2.0
Reporter: Ken Johanson
Priority: Minor
DML with datetime literals having timzone offset data (ISO-8601):
update tbl set dt1 = '2007-01-03 04:13:43.006 -0800'
Causes:
SQLException: The syntax of the string representation of a datetime value is
incorrect.
Error: -1 SQLSTATE: 22007
I believe that even if the storage does not (does it?) support timezone
storage, the input of a TZ could be normalized (offset applied) to the default
TZ.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
