Ce contenu n'est pas disponible dans la langue sélectionnée.
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.
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…]]' |