JDBC escape syntax for timestamp formats
Derby Reference Manual
332
VALUES {d '2010-10-19'}
JDBC escape syntax for timestamp formats
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'}