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

Add support for ODBC 3.0 functions

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 10.3, 8.12.15.6_4
    • 8.12.12.6_4
    • Query Engine
    • None

      Looking to add support for ODBC 3 functions like "CURRENT_TIMESTAMP" and "CURRENT_DATE()" as indicated in linke [1]. This would be in support of applications that auto-generate backend SQL such as Tableau or Spotfire.

      [1] https://docs.microsoft.com/en-us/sql/odbc/reference/appendixes/time-date-and-interval-functions?view=ssdt-18vs2017

            [TEIID-5317] Add support for ODBC 3.0 functions

            Steven Hawkins added a comment -

            Added current_date(), current_time[(precision)], and current_timestamp[(precision)] to Teiid. To conform to our expectations the current_time precision is ignored. We also only get the current_timestamp to at most millisecond resolution.

            Steven Hawkins added a comment - Added current_date(), current_time [(precision)] , and current_timestamp [(precision)] to Teiid. To conform to our expectations the current_time precision is ignored. We also only get the current_timestamp to at most millisecond resolution.

              rhn-engineering-shawkins Steven Hawkins
              rhn-support-mshirley Marc Shirley (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: