HOW TO GET TIMESTAMP VALUE

Database
Enthusiast

HOW TO GET TIMESTAMP VALUE

source date format

8/18/2014 3:55:45 PM

I am given as Timestamp(0) in TERADATA 

e.g – DOJ Timestamp(0)

it is not working

I LOADING A FILE  TO THE TERADATA

What should be my data type in DDL

ADV THNX