JDBC escape syntax for timestamp formats interprets the JDBC escape syntax for timestamp formats as equivalent to the correct SQL syntax for timestamps. ts (JDBC escape keyword){ts (JDBC escape syntax)Timestamp formatsJDBC escape syntax for

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'}