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 [1]
ts
Timestamp
yyyy-mm-dd hh:mm:ss[.f...]
Note
: If you receive an error while running a query in Visual Studio to insert data into the Date field of a table, ensure that your system's Date format is set to
yyyy-mm-dd
. If not, change it to
yyyy-mm-dd
.
Example
UPDATE Orders SET OpenDate={d '1997-01-29'}
WHERE OrderID=1023