Archives of the TeradataForum

Message Posted: Tue, 02 Apr 2002 @ 20:56:28 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

This is ANSI standard. See the SQL Reference, Vol. 3, pp. 2-10 - 2-18 (=PDF pp. 38-46). I quote:

ANSI DateTime Literals Require a Keyword

ANSI SQL DateTime literals differ from other SQL literals in that they are always prefaced by a keyword or keywords.

For example, a TIMESTAMP literal requires the keyword preface TIMESTAMP with the timestamp literal as shown by the following example.

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

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

Geoffrey Rommel
Certified Teradata Master (just today!)

	<Prev	Next>		<<First	<Prev	Next>	Last>>