[teiid-issues] [JBoss JIRA] (TEIID-4114) Expanding logic in the format conversion for parsing and formatting of dates

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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. 



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)