title: ERROR when using getDate() in oracle to update rows
body: <p>I have a table with a column called STREAM_TIME of DATE type.<br>
  I'm trying to update all rows for that column to today's date. The database used is oracle.</p>
  
  <p>My query:  </p>
  
  <pre><code>update bns_bess_messages SET stream_time=getDate();
  </code></pre>
  
  <p>Oracle comes back with this error:</p>
  
  <pre><code>SQL Error: ORA-00904: "GETDATE": invalid identifier
  00904. 00000 -  "%s: invalid identifier"
  </code></pre>
  
  <p><strong>How can I update STREAM_TIME to today's date?</strong>  </p>
  
  <p>Thanks</p>