I have data that is formatted like
|Fri Dec 20 15:15:18 +0000 2013|
I want to fastload this data into Teradata with a Timestamp but I am not sure of the format..
I tried the below but it didnt work.
,eny_ts TIMESTAMP format 'dddbmmmbddbhh:mi:ssbhhhhbyyyy'
Any help would be really appreciated
There is a chain of communication about date conversion in fastload.
TD has many date format conversion like TIMESTAMP,TIMESTAMP (n),TIMESTAMP WITH TIME ZONE,TIMESTAMP (n) WITH TIME ZONE etc.