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

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-2969:
-------------------------------------

             Summary: 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.7.1, 8.8


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.2.3#6260)