Teiid supports function FROM_UNIXTIME as a result of
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