The JDBC specification defines escapes for specifying date, time and timestamp values which are supported by the driver.
date >
{d 'yyyy-mm-dd'}
which is translated toDATE 'yyyy-mm-dd'
time >
{t 'hh:mm:ss'}
which is translated toTIME 'hh:mm:ss'
timestamp >
{ts 'yyyy-mm-dd hh:mm:ss.f...'}
which is translated toTIMESTAMP 'yyyy-mm-dd hh:mm:ss.f'
> The fractional seconds (.f…) portion of the TIMESTAMP can be omitted.