FastLoad Date Foramt for Long Unix Date

Database

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 (1)
2 REPLIES

Re: FastLoad Date Foramt for Long Unix Date

I just need some help

Enthusiast

Re: FastLoad Date Foramt for Long Unix Date

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