Archives of the TeradataForum

Message Posted: Mon, 31 Jan 2011 @ 19:49:56 GMT

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

When defining default values for decimal fields in a create table statement. Does Teradata handle the following any differently? Thanks.

     Field1 DECIMAL(9,3) NOT NULL DEFAULT 0.0 COMPRESS 0.0

Or

     Field1 DECIMAL(9,3) NOT NULL DEFAULT 0.000 COMPRESS 0.000

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