Constants

You can use constants in expressions. Available constants include Date, Time, and Timestamp. See also Current_Date, Current_Time, and Current_TimeStamp.

Constant	Example	Description
Date	DATE [2014-04-09]	Inserts a specific date.
Time	TIME [12:00:00]	Inserts a specific time.
TimeStamp	TIMESTAMP [2014-04-09 12:00:00]	Inserts a specific timestamp.