3.3. Conversion of String Literals
3.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' 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.
SELECT * FROM my.table WHERE created_by = '2003-01-02'