JDBC escape syntax for date formats

Derby interprets the JDBC escape syntax for dates as equivalent to the correct SQL syntax for dates.

Syntax

{ d 'yyyy-mm-dd' }

Equivalent to

DATE('yyyy-mm-dd')

Example

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