Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2969

timestamp parse format issues

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.8, 8.7.1
    • 7.7
    • Misc. Connectors
    • None

    Description

      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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: