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?
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":