Archives of the TeradataForum

Message Posted: Tue, 19 Oct 2010 @ 09:47:32 GMT

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

Hi all!

I do the following:

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

     insert into DW_STAGING.t1 Select NULL

It fails? Why? It has default value.

Thanks in advance.

Best regards,

Dmitriy Boyko

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