Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

4.6. Escaped Literal Syntax

Rather than relying on implicit conversion, data type values may be expressed directly in SQL using escape syntax to define the type. Note that the supplied string value must match the expected format exactly or an exception will occur.

Table 4.5. Escaped Literal Syntax

Data type Escaped Syntax
DATE {d 'yyyy-mm-dd'}
TIME {t 'hh-mm-ss'}
TIMESTAMP {ts 'yyyy-mm-dd hh:mm:ss.[fff...]'}