Datetime constants

A datetime constant specifies a date, time, or timestamp. Typically, character-string constants are used to represent constant datetime values in assignments and comparisons. However, the ANSI/ISO SQL standard form of a datetime constant can be used to specifically denote the constant as a datetime constant instead of a character-string constant. For more information see String representations of datetime values.

Example

   DATE '2003-09-03'