JDBC Reference
Page 31 of 31

ts

Cloudscape interprets the JDBC escape syntax for timestamp as equivalent to the correct SQL-J syntax for timestamps.

Syntax

{ts 'yyyy-mm-dd hh:mm:ss.f...'}

Equivalent to

TIMESTAMP 'yyyy-mm-dd hh:mm:ss.f...'

The fractional portion of timestamp constants (.f...) may be omitted.

Example

VALUES {ts '1999-01-09 20:11:11.123455'}