Skip to main content
Skip table of contents

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.

Data type

Escaped syntax

DATE

{d 'yyyy-mm-dd'}

TIME

{t 'hh-mm-ss'}

TIMESTAMP

{ts 'yyyy-mm-dd hh:mm:ss.[fff...]'}

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.