[teiid-issues] [JBoss JIRA] (TEIID-2969) timestamp parse format issues

[Steven Hawkins (JIRA)]

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

Steven Hawkins closed TEIID-2969.
---------------------------------


> timestamp parse format issues
> -----------------------------
>
>                 Key: TEIID-2969
>                 URL: https://issues.jboss.org/browse/TEIID-2969
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 7.7
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.8, 8.7.1
>
>
> Oracle and Postgresql pushdown of parse/format of timestamps is generally incorrect as the format string is left unquoted. Also Postgresql does not support the same syntax as oracle.
> Also pushdown of timestampdiff is not correct for pg for fields other than DAY and YEAR.  Fractional seconds are not implemented and all of the other fields seem to return just the calendar field difference, not the number of intervals different - e.g. the difference in hours for timestamps that are years apart is just the 24 hour difference.



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)