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:
| | |
d | Date | yyy-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