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

Add function to transform timestamp into Unix time

    Details

    • Type: Feature Request
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 10.0
    • Component/s: Query Engine
    • Labels:
      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                jstastny Jan Stastny
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: