Archives of the TeradataForum
Message Posted: Tue, 02 Apr 2002 @ 20:56:28 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|