I am using Copy command to load a file in table. It has a timestamp column.
In my File format I have defined Timestamp as other and gave value as MM/DD/YYYY HH:MI:SS AM to match with data.
When I execute it loads all records which have timestamp with AM format and any records with timestamp of PM time fails in Copy.
Sample fail record: 1, abc, 04/12/2016 12:00:00 PM
Sample successfully Loaded Record: 2, erd, 04/12/2016 08:00:00 AM
To verify my timestamp format I used below query and it worked fine: SELECT TO_TIMESTAMP('04/12/2016 12:00:00 PM','MM/DD/YYYY HH:MI:SS AM')