[teiid-issues] [JBoss JIRA] Closed: (TEIID-248) Add function for calculating timestamp based on Unix time (like MySQL FROM_UNIXTIME function)

[Steven Hawkins (JIRA)]

     [ https://jira.jboss.org/jira/browse/TEIID-248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-248.
--------------------------------



> Add function for calculating timestamp based on Unix time (like MySQL FROM_UNIXTIME function)
> ---------------------------------------------------------------------------------------------
>
>                 Key: TEIID-248
>                 URL: https://jira.jboss.org/jira/browse/TEIID-248
>             Project: Teiid
>          Issue Type: Feature Request
>    Affects Versions: 6.0.0
>            Reporter: Marc Shirley
>            Assignee: Steven Hawkins
>            Priority: Minor
>             Fix For: 6.0.0
>
>   Original Estimate: 4 hours
>  Remaining Estimate: 4 hours
>
> 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.  

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira