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

Add function for calculating timestamp based on Unix time (like MySQL FROM_UNIXTIME function)

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Minor
    • 6.0.0
    • 6.0.0
    • None
    • None
    • Documentation (Ref Guide, User Guide, etc.), Release Notes
    • Low

    Description

      Add a function to take a value in seconds and return a timestamp value. Client use case of storing the unix time created a need for a way to convert the value to a timestamp. A workaround is available by using TIMESTAMPADD to add the seconds recorded in the unix time value to a timestamp value created from January 1, 1970 GMT.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 4 hours
                4h
                Remaining:
                Remaining Estimate - 4 hours
                4h
                Logged:
                Time Spent - Not Specified
                Not Specified