Constants

You can use constants to include specific dates and times in expressions.

Available constants include Date, Time, and Timestamp.

Constant	Example	Description	Syntax
DATE	DATE [2014-04-09]	Inserts a specific date.	DATE [yyyy-mm-dd]
TIME	TIME [12:00:00]	Inserts a specific time.	TIME [hh:mi:ss]
TIMESTAMP	TIMESTAMP [2014-04-09 12:00:00]	Inserts a specific timestamp.	TIMESTAMP [yyyy-mm-dd hh:mi:ss]