title: Update date field of one table from the value taken from another table
body: <p>I have two table A and B where both have date fields but in different format('MM/DD/YYYY HH:MI:SS' and 'MM/DD/YYYY') and they both have a common field called invoiced_value. I need to update the date values of table A(with 'MM/DD/YYYY HH:MI:SS') from the values of table B(with 'MM/DD/YYYY'). Can i use the following query?. can i append the date like this to_date(e.invoiced_date ||' 3:56:24', 'MM/DD/YYYY HH:MI:SS') ?.</p>
  
  <pre><code>  UPDATE Table1
    SET m.invoiced_date = to_date(e.invoiced_date ||' 3:56:24', 'MM/DD/YYYY HH:MI:SS')
    FROM Table2 e, Table1 m
    WHERE m.invoiced_value = e.invoiced_value
  </code></pre>