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

      Hi

        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.

       

      Regards,

      Avinash