title: SET Date in Column A of type TIMESTAMP in DB2
body: <p>I am running following DB2 query:</p>
  
  <pre><code>UPDATE Table
  SET DATE(COLA) = '2017-03-31'
  WHERE DATE(COLA) = '2017-03-29'; 
  </code></pre>
  
  <p>COLA is of type TIMESTAMP.</p>
  
  <p>Sample Value:</p>
  
  <pre><code>COLA:
  2017-03-29-00.00.00.000000
  </code></pre>
  
  <p>Expected Updated Value:</p>
  
  <pre><code>COLA:
  2017-03-31-00.00.00.000000
  </code></pre>
  
  <p>When I am running above query, I am getting</p>
  
  <blockquote>
    <p>SQL Code SQLCODE = -104,ERROR:  ILLEGAL SYMBOL "(". SOME SYMBOLS THAT
    MIGHT BE LEGAL ARE: = .</p>
  </blockquote>
  
  <p>Could anyone help me out for this scenario? </p>
  
  <p>Thanks a lot!</p>