All Forums Database
ddewber 4 posts Joined 12/13
20 Dec 2013
FastLoad Date Foramt for Long Unix Date

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

Tags:
ddewber 4 posts Joined 12/13
20 Dec 2013

I just need some help

Raja_KT 1246 posts Joined 07/09
20 Dec 2013

Hi,
There is a chain of communication about date conversion in fastload.
http://forums.teradata.com/forum/tools/fastload-datetime-timestamp
 
TD has many date format conversion like TIMESTAMP,TIMESTAMP (n),TIMESTAMP WITH TIME ZONE,TIMESTAMP (n) WITH TIME ZONE etc.
 
Cheers,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.