[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=13460009#comment-13460009 ] 

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

Like I indicated above. I've thought of this enhancement as adding the reverse option to FROM_UNIXTIME, which works with seconds. So this enhancement can be considered exactly that.

The MySQL implementation returns seconds.

PostgreSQL on the other hand offers more complex solution with using export function https://www.postgresql.org/docs/9.2/static/functions-datetime.html which is probably larger scope though.


> 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)