7 Replies Latest reply on Oct 18, 2018 5:58 AM by Marc Kusters

    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.