title: Replacing month in TimeStamp from Date
body: <p>I am new to Oracle DB and have a situation in hand.<br>
  I have two tables.  </p>
  
  <pre><code>Table1 [ ID, MY_DATE ]
  Table2 [ ID, MY_TIMESTAMP]
  </code></pre>
  
  <p>I need to pick the <code>month</code> alone from <code>Table1.MY_DATE</code> and replace the corresponding month at <code>Table2.MY_TIMESTAMP</code>.<br>
  Both Table1 and Table2 are joined by ID.</p>
  
  <p>How do I pick the month alone from a Date column and replace month alone in a TimeStamp field.<br>
  Can anyone please help?</p>