ts

Derby interprets the JDBC escape syntax for timestamp as equivalent to the correct SQL syntax for timestamps. Derby also supports the ISO format of 23 characters (17 digits, 3 dashes, and 3 decimal points).

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...) can be omitted.

Example

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