Archives of the TeradataForum

Message Posted: Wed, 04 Sep 2013 @ 23:30:36 GMT

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

Try the following DDL for you default timestamp.

     CREATE TABLE edw2.t1
     (record_end_dtm TIMESTAMP(6)  NOT NULL DEFAULT  TIMESTAMP '2011-12-31 11:59:00.000000' )

Regards,

Jim

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