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

Example:
UPDATE Orders SET OpenDate={d '1995-01-15'} 
WHERE OrderID=1023 

Previous Document Previous Page Next Document Next Page Synchronize TOC Synchronize with Contents