Load Timestamp

Teradata Studio
Teradata Employee

Load Timestamp

Currently

2 REPLIES
Teradata Employee

Re: Load Timestamp

What table column data type makes sense for loading timestamp data from Excel ?

Currently using DT_Stamp TIMESTAMP(6) FORMAT "MM/DD/YYYYbHH:MI"

Excel data has:

2/5/2013 3:10:00 PM

Teradata Employee

Re: Load Timestamp

Paul, The FORMAT clause only applies to exporting data from the table. From the Teradata “SQL Data Types and Literals” manual: FORMAT pertains to data exported in report form, as is the case in BTEQ. FORMAT does not control internal storage representation of data or data returned in record or indicator variable mode. The Teradata default timestamp format is: YYYY-MM-DD HH:MMSS.S(F). You will need the timestamp in that format from Excel. Can you set the format of the column in Excel to match Teradata? Another option is to load it as a VARCHAR.