Archives of the TeradataForum

Message Posted: Tue, 19 Oct 2010 @ 09:02:00 GMT

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

Hi Madhu,

Actual format of timestamp with time zone literal is:

     2010-10-19 03:54:33.180000+00:00  <<<<< observe no space (only +) between seconds and time zone

Change your DDLs as follows:

     create table t1 (record_end_dtm TIMESTAMP(6) with TIME ZONE FORMAT 'YYYY-MM-
     DDBHH:MI:SS.S(6)BZ ' NOT NULL DEFAULT Timestamp '9999-12-31 11:59:00.000000+06:00' );
     create table DW_STAGING.t1(record_end_dtm TIMESTAMP(6) with TIME ZONE FORMAT 'YYYY-MM-
     DDBHH:MI:SS.S(6)BZ' NOT NULL DEFAULT Timestamp '9999-12-31 11:59:00.000000+00:00' );

-Vipin

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