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

wrong type info for EPOCH return value

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 15.0, 13.1.2, 14.0.1
    • 14.0
    • Query Engine
    • None
    • DV Sprint 65
    • 0.1

    Description

      The documentation states that EPOCH(..) and EXTRACT(EPOCH FROM ..) return double. I should be able to perform calculations on those. For example, I should be able to find the number of seconds since the epoch with

      SELECT EPOCH(NOW()) / 1000;
      

      However, this query produces the error

      TEIID30070 The function '(EPOCH(NOW()) / 1000)' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.

       

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            kgeis Ken Geis (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 45 minutes
                45m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 45 minutes
                45m