Show Table of Contents
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.
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.