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 Dateyyyy-mm-dd
t Timehh:mm:ss [1]
ts Timestampyyyy-mm-dd hh:mm:ss[.f...]
Example:
UPDATE Orders SET OpenDate={d '1995-01-15'} WHERE OrderID=1023
![]() |
Previous Page |
![]() |
Next Page |
![]() |
Synchronize with Contents |