The escape syntax

Escape syntax indicates information that must be translated from JDBC format to HCL OneDB™ native format. Valid escape syntax for SQL statements is as follows.

Type of statement	Escape syntax
Procedure	{call procedure}
Function	{var = call function}
Date	{d 'yyyy-mm-dd'}
Time	{t 'hh:mm:ss'}
Timestamp (Datetime)	{ts 'yyyy-mm-dd hh:mm:ss[.fffff]'}
Function call	{fn func[(args)]}
Escape character	{escape 'escape-char'}
Outer join	{oj outer-join-statement}
Limit	{limit number-to-limit}
Skip	{limit number-to-limit number-to-skip}

You can put any of this syntax in an SQL statement, as follows:

executeUpdate("insert into tab1 values( {d '1999-01-01'} )");