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. For example:

In the preceding example, if the created_by column has the data type of date, Teiid automatically converts the data type of the string literal to a date.

Teiid can automatically convert literal strings and numeric type values to Boolean values as shwon in the following table:

Teiid can implicitly convert properly formatted literal strings to their associated date-related data types as shown in the following table:

The preceding formats are those expected by the JDBC date types. For information about using other formats, see the functions PARSEDATE, PARSETIME, and PARSETIMESTAMP in Date and time functions.