[teiid-issues] [JBoss JIRA] (TEIID-4656) parseTimestamp issue with Oracle

[Steven Hawkins (JIRA)]

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

Steven Hawkins closed TEIID-4656.
---------------------------------


> parseTimestamp issue with Oracle
> --------------------------------
>
>                 Key: TEIID-4656
>                 URL: https://issues.jboss.org/browse/TEIID-4656
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector, Query Engine
>    Affects Versions: 8.12
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.2, 8.12.9.6_3, 8.7.11.6_2
>
>
> parseTimestamp is pushed as to_timestamp.  However TO_TIMESTAMP is not generally valid unless the format string covers the entire string input value otherwise there is an exception about the picture ending.  
> This means in general that we cannot pushdown the parseDate/Time/Timestamp operations to oracle as that is behavioral different with the java format routines, which will process just to the end of the format string.  



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)