Teiid automatically converts string literals within a SQL statement to their implied types. This typically occurs in a criteria comparison where an expression with a different datatype is compared to a literal string:

Here if the created_by column has the datatype of date, Teiid automatically converts the string literal to a date datatype as well.

Teiid can automatically convert literal strings and numeric type values to Boolean values as follows:

Teiid can implicitly convert properly formatted literal strings to their associated date-related datatypes as follows:

The formats above are those expected by the JDBC date types. To use other formats see the functions PARSEDATE , PARSETIME , PARSETIMESTAMP .