2 Replies Latest reply on Jul 5, 2018 1:31 AM by Avinash Chandwani

    Looking to convert timestamp into UNIX epoch value in release 9

    Avinash Chandwani Newbie


        I am looking to convert timestamp to unix epoch value.


        I could see that it is implemented as to_millis in release 10  [TEIID-5026] Add function to transform timestamp into Unix time - JBoss Issue Tracker


      Is there a way to be able to do conversion prior to this release?


      Or any means to find out the timezone of TEIID system from SQL query.