Date, Time, and Timestamp Escape Sequences

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

{literal-type 'value'} 

where literal-type is one of the following:

Example:

UPDATE Orders SET OpenDate={d '1997-01-29'} 
WHERE OrderID=1023