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:
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