9 Replies Latest reply on Aug 28, 2015 6:40 PM by Ramesh Reddy

    Teiid CONVERT vs CAST

    Sathish Kumaran Vairavelu Newbie



      Wondering why TEIID uses CONVERT function instead of CAST function in the SQL's. I am trying to run the SQL statements from the plan XML in the database and I have encountered with this error. Are there are any ways that we can force TEIID to use CAST function instead of CONVERT function. I believe most databases uses CAST for typecasting as against CONVERT.