I have a flat file with sample record as shown below:
I have created the target table with column for date as timestamp. When I try to insert the record into the target table after casting:
CAST(UPDATE_STAMP AS TIMESTAMP(0) FORMAT ''yyyy-mm-ddBhh:mi:ss.SSSSSS''),
I am getting an error message:
I would have to see more of the script to tell, but there is probably another single quote that needs to be escaped somewhere.