4.3. Conversion of String Literals

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

SELECT * FROM my.table WHERE created_by = '2003-01-02'

SELECT * FROM my.table WHERE created_by = '2003-01-02'

Here if the created_by column has the data type of date, JBoss Data Virtualization automatically converts the string literal to a date data type as well.