 |
 |
Archives of the TeradataForum
Message Posted: Wed, 22 Nov 2006 @ 09:41:37 GMT
| Subj: | | Re: Length of timestamp |
| |
| From: | | Victor Sokovin |
| | 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. | |
If you created the table using an ODBC tool there is a possibility that your DDL has been changed by the tool before it was submitted to
Teradata. Timestamps of this kind used to be translated to CHAR(n) because the ODBC driver had a problem with passing them on. Use SHOW TABLE to
verify the table definition as it is in the database. There might be a surprise waiting for you there.
To fix the problem just submit the DDL using BTEQ.
Regards,
Victor
| |
