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

Add function to transform timestamp into Unix time

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 10.0
    • None
    • Query Engine
    • None

    Description

      Teiid supports function FROM_UNIXTIME as a result of TEIID-248.

      There isn't its reverse counterpart though.

      This is an issue, when there is a data source which doesn't support timestamp/date/time data types:

      • users choose to use long(unix time) in the source
      • by using FROM_UNIXTIME function they transform the long value (unix time) into respective data type value in their virtual model
      • they can read such source.
      • they can't insert/update it as this would require 'INSTEAD OF TRIGGER' with ability to transform timestamp/time/date back to long value - Unix time. This part is missing.

      As an example could serve MySQL's UNIX_TIMESTAMP

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            jstastny@redhat.com Jan Stastny
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: