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