Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Inserting a Timestamp value
From:   Geoffrey Rommel

  Is this format of literal timestamp described in any Teradata manual? Is this specification ANSI or just Teradata. Thanks.  

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023