title: AWS Redshift DEFAULT TIMESTAMP
body: <p>I am moving some data from old system to AWS -- and I am following the current protocol:</p>
  
  <ul>
  <li>Create new tables</li>
  <li>Load data in buckets</li>
  <li>Copy from bucket to table</li>
  </ul>
  
  <p>This works great so far, but I am having an issue with empty TIMESTAMPS (some versions of my dates are unavailable -- so I have them set to a default date on my old version, but on the new version, they are being loaded as NULL)  </p>
  
  <p>For each time NULL appears in my aws date column, I want to replace it with '0000-00-00 00:00:00' for example.  This is crucial so that I can run an EXCEPT function on the two tables (old &amp; new) to verify the robustness of the process.  </p>
  
  <p>I have tried explicit commands like REPLACE, INSERT, </p>
  
  <p>I have rebuilt the table with date column default '0000-00-00 00:00:00'</p>
  
  <p>No luck so far.  Any help would be great!  Thanks!</p>