]
Steven Hawkins updated TEIID-4114:
----------------------------------
Component/s: JDBC Connector
Fix Version/s: 9.0
8.12.5
Workaround Description: Use HH for the hour format.
Workaround: Workaround Exists
Affects Version/s: 8.11
Expanding logic in the format conversion for parsing and formatting
of dates
----------------------------------------------------------------------------
Key: TEIID-4114
URL:
https://issues.jboss.org/browse/TEIID-4114
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 8.11
Reporter: Johnathon Lee
Assignee: Steven Hawkins
Fix For: 9.0, 8.12.5
Java documentation isn't explicit
https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html regarding
date/time formats.
The format string is not enforced on the parsing side, so any hour format will accept any
value. However oracle's behavior is different - if you specify HH vs HH24, then 13-23
is disallowed.
Need to address this by expanding the logic in the format conversion to account for the
difference between parsing and formatting.