skip to main content
Configuring Hybrid Data Pipeline for JDBC : SQL escape sequences : Date, Time, and Timestamp escape sequences
  

Try Now

Date, Time, and Timestamp escape sequences

Syntax

{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 []
ts
Timestamp
yyyy-mm-dd hh:mm:ss[.f...]

Example

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