[teiid-issues] [JBoss JIRA] (TEIID-5026) Add function to transform timestamp into Unix time

[Jan Stastny (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13460301#comment-13460301 ] 

Jan Stastny commented on TEIID-5026:
------------------------------------

[~shawkins] for the JDG integration there is a workaround with using string data type in source DDL instead of timestamps.
So this enhancement can be considered outside of that context.

> Add function to transform timestamp into Unix time
> --------------------------------------------------
>
>                 Key: TEIID-5026
>                 URL: https://issues.jboss.org/browse/TEIID-5026
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Jan Stastny
>            Assignee: Steven Hawkins
>             Fix For: 10.0
>
>
> 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|https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_unix-timestamp]



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)