> Is there a way to be able to do conversion prior to this release?
Assuming you want the number of seconds you could use: timestampdiff(SQL_TSI_SECOND, FROM_UNIXTIME(0), timestampValue)
> Or any means to find out the timezone of TEIID system from SQL query.
There's not a great way of doing that unfortunately. The closest would be to enable the ENV function and access the system property for the timezone.
Thanks a lot Steven for your quick help. It works