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.