Archives of the TeradataForum
Message Posted: Fri, 01 Dec 2006 @ 11:09:13 GMT
| Subj: | | Re: Length of timestamp |
| |
| From: | | Dieter Noeth |
Anomy.Anom wrote:
| | I'm not sure if I did something incorrectly in the BTEQ above or am misreading the doc but can anyone help me confirm this? | |
OK, there's another manual ;-)
SQL Reference: Data Types and Literals
Chapter 4: DateTime and Interval Data Types
TIMESTAMP Data Type
Internal Representation of TIMESTAMP
...
Conceptually, TIMESTAMP is treated as a record composed of six fields, defined appropriately for the Gregorian calendar.
...
The length of the internal stored form is 10 bytes.
...
External Representation of TIMESTAMP
TIMESTAMP types are imported and exported in record and indicator modes as CHARACTER data using the ANSI format string
Dieter
| 
