JDBC escape syntax for timestamp formats ts (JDBC escape keyword){ts (JDBC escape syntax)Timestamp formatsJDBC escape syntax for

interprets the JDBC escape syntax for timestamp as equivalent to the correct SQL syntax for timestamps. 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.

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