Archives of the TeradataForum

Message Posted: Mon, 05 May 2003 @ 15:26:52 GMT

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

Try

The DDL for the field is

CREATE SET TABLE tab1 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL
(
DEPT_ID DECIMAL(15,0) NOT NULL,
END_DT DATE FORMAT 'yyyy-mm-dd' COMPRESS -18989899
)
PRIMARY INDEX ( DEPT_ID );

This is the converted value for 0001-01-01

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