Date, Time, and Timestamp Escape Sequences
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 9.0
- Documentation
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 | 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