DateTime Literals - Teradata Vantage

The ANSI SQL DateTime literals provide DateTime values in source text, supporting a means for declaring values for DATE, TIME, and TIMESTAMP data types.

Keywords for ANSI DateTime Literals

Unlike other SQL literals, ANSI SQL DateTime literals are prefaced by a keyword or keywords.

Here is an example showing the TIMESTAMP keyword prefacing a timestamp literal:

TIMESTAMP '1999-07-01 15:00:00-08:00'

Literals expressed in this format are interpreted exclusively as ANSI DateTime values.