skip to main content
SQL Escape Sequences : Date, Time, and Timestamp Escape Sequences
 

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