3.6. Escaped Literal Syntax
3.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. Ensure the string value you supply matches the expected format exactly or an exception will occur. Table 3.5. Escaped Literal Syntax Data type Escaped Syntax Standard Literal BOOLEAN {b 'true'} TRUE DATE {d 'yyyy-mm-dd'} DATE 'yyyy-mm-dd' TIME {t 'hh-mm-ss'} TIME 'hh-mm-ss' TIMESTAMP {ts 'yyyy-mm-dd hh:mm:ss.[fff...]'} TIMESTAMP 'yyyy-mm-dd[ hh:mm:ss.[fff...]]'