Show Table of Contents
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…]]' |
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.