Archives of the TeradataForum
Message Posted: Tue, 21 Nov 2006 @ 20:40:07 GMT
We tried to use the TIMESTAMP(6) for data type in a table, in the documentation it's say than the length of the internal stored form is 10 bytes for a timestamp data type. Surprise, the length we see in DBC.COLUMNS views for our table is 26 bytes. If I looked for all DBC tables how their timestamp as been defined, they are fine with 10 bytes.
The way we define the table is :
CREATE SET TABLE DATA_BASE.TTABLE_NAME ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( TOC_TOC_TOC INTEGER, DHC_OCC_DP_ACTE_MD TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6)) PRIMARY INDEX ( TOC_TOC_TOC );
Is their a system variable to set?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|