openGauss-connector-jdbc/docs/documentation/94/escapes-datetime.md

layout, title, header, resource, previoustitle, previous, nexttitle, next

layout	title	header	resource	previoustitle	previous	nexttitle	next
default_docs	Date-time escapes	Chapter 8. JDBC escapes	media	Escape for outer joins	outer-joins-escape.html	Escaped scalar functions	escaped-functions.html

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 to DATE 'yyyy-mm-dd'

time

{t 'hh:mm:ss'} which is translated to TIME 'hh:mm:ss'

timestamp

{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.