Archives of the TeradataForum

Message Posted: Tue, 21 Nov 2006 @ 20:40:07 GMT

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

Hi all,

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?

RS

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