Escaped literal syntax
Rather than relying on implicit conversion, you can define data type values directly in SQL by using escape syntax. The string values that you supply must match the expected format exactly, or an exception will occur.
Datatype | 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…]]' |