TPT API, TimeStamp(0)

Tools
Enthusiast

TPT API, TimeStamp(0)

Hi:

I am trying to use TPT API to import data into Teradata. From other forum posts, Date is 4 Bytes and can be represented as "date = (Year - 1900) * 10000 + Month * 100 + Day".

For TimeStamp, I cannot find anything in the sample code or forum about it. How to store timestamp with 0 precision in a byte array and write the buffer into Teradata using TPT API?

Thanks,

J.D.

1 REPLY
Junior Contributor

Re: TPT API, TimeStamp(0)

There's no binary represenation for TIMESTAMPs, it must be a CHAR.

"TPT API Programmer Guide", chapter 9 "Converting TIME, TIMESTAMP, and INTERVAL Data Types":

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Load_and_Unload_Utilities/B035_25...