Archives of the TeradataForum

Message Posted: Mon, 18 Oct 2010 @ 19:58:55 GMT

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

Hello,

Thanks in advance for the knowledge you guys are sharing.

I am trying to Create AND INSERT a default value of timestamp with timezone into a DATE columns defined as below. I am not able to get it to work. Any help is appreciated

     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' )

This above create works ..

I was wondering if we can create with the time zone literal too. like using the DDL statements as below (both are not working) 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 6' )

or

     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 with time zone
     '9999-12-31 11:59:00.000000 +00:00' )

AND I am also trying to insert a timestamp and timezone as a literal like below which gives invalid Timestamp error.

     insert into t2 values (   '9998-12-31 11:59.00.000000 6'  )
     insert into t2 values (   '9998-12-31 11:59.00.000000 00:00'  )

I am not sure if I am missing any information on TimeZONE and how its used inTeradata.

Thank You,

MGajsk.

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