JDBC escape syntax for time formats

Derby interprets the JDBC escape syntax for time formats as equivalent to the correct SQL syntax for times.

Derby also supports the ISO format of 8 characters (6 digits, and 2 decimal points).

Syntax

{ t 'hh:mm:ss' }

Equivalent to

TIME('hh:mm:ss')

Example

VALUES {t '20:00:03'}
Related reference
JDBC escape keyword for call statements
JDBC escape syntax for LIKE clauses
JDBC escape syntax for limit/offset clauses
JDBC escape syntax for fn keyword
JDBC escape syntax for outer joins
JDBC escape syntax for date formats
JDBC escape syntax for timestamp formats