title: Teradata error - importing timestamp column with null values
body: <p>I have a timestamp column in a delimter file in the format '12/04/2018 15:38:42' and I am trying to import this file thro Teradata SQL assistant. I have defined the target table with this column as<br>
  SYSTEM_DT     Timestamp(0) FORMAT 'MM/DD/YYYYBHH:MI:SS'
  I am using the below statement to import, its loading fine until it detects a null value on the file for this column. I am getting 'Invalid timestamp' error.</p>
  
  <pre><code>INSERT INTO TARGET_TABLE
  VALUES (CAST(? AS TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SS'),?,?,?)
  </code></pre>
  
  <p>So I tried below, nothing worked - <br>
  1. <code>CAST(COALESCE(? , '01/01/1900 00:00:00') AS TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SS')</code><br>
  2. <code>COALESCE(CAST(? AS TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SS'), CAST('01/01/1900 00:00:00' AS TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SS'))</code>
  <br>
  Please help.</p>