|
|
Archives of the TeradataForum
Message Posted: Tue, 21 Nov 2006 @ 20:40:07 GMT
Subj: | | Length of timestamp |
|
From: | | Simard Rudel |
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
| |