Date-time escapes

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.

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group