]
Steven Hawkins resolved TEIID-4114.
-----------------------------------
Resolution: Done
Differentiated the parse/format so that we'll use HH24 for parsing.
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.