Archives of the TeradataForum

Message Posted: Tue, 19 Oct 2010 @ 09:03:16 GMT

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

Hi,

The insert is failing because your literals are not formatted correctly.

As per the SQL Reference Data Types and Literals manual, Timestamp with time zone literals in Teradata have to:

- start with the word TIMESTAMP

- have colons (:) after the hour and minute values

- have a leading sign (either + or -)

- use 2 digits for hours and 2 digits for minutes.

So try:

     insert into t2 values (TIMESTAMP   '9998-12-31 11:59:00.000000+06:00'  )
     insert into t2 values (TIMESTAMP   '9998-12-31 11:59:00.000000+00:00'  )

Cheers,

Dave

Ward Analytics Ltd - Information in motion ( www.ward-analytics.com )

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