The escape sequence for date, time, and timestamp literals is:

{literal-type 'value'}

where:

literal-type
is one of the following:
literal-type Description Value Format
d Date yyyy-mm-dd
t Time hh:mm:ss []
ts Timestamp yyyy-mm-dd hh:mm:ss[.f...]

Example:

UPDATE Orders SET OpenDate={d '1995-01-15'} WHERE OrderID=1023