Date, Time, and Timestamp Escapes
- Last Updated: April 16, 2026
- 1 minute read
- ADO.NET
- Documentation
The escape sequence for date, time, and timestamp literals is:
{literal-type 'value'}
where literal-type is one of the following:
|
|
Description | Value Format |
| d | Date | yyyy-mm-dd |
| t | Time | hh:mm:ss [1] |
| ts | Timestamp | yyyy-mm-dd hh:mm:ss[.f...] |
Example:
UPDATE Orders SET OpenDate={d '1997-01-29'} WHERE OrderID=1023