title: update date value in oracle
body: <p>I need to convert date format in ORACLE SQL Developer</p>
  
  <p>The current format is yyyy/mm/dd-hh:mm:ss:sss and I need to convert it to yyyy-mm-dd hh:mm:ss CST
  I don't really know SQL but did some research.
  Here is the command that I consultanted other people on the forum. but it throws me unrecognized command error. table name is B and column name is First</p>
  
  <pre><code>UPDATAE B
  set First = concat(to_char(substring(FIRST,1,4) + '-' + substring(FIRST, 6, 2) + '-' + substring(FIRST, 9, 2) + ' ' + substring(FIRST, 12, 8));
  </code></pre>
  
  <p>Could anyone here help me with it? thanks in advance.</p>