title: Update only the date from datetime - Oracle
body: <p>I have a column with datatype Date time and so contains value such as:<code>06-FEB-12 02.39.11.000000000 PM</code>. I wanted to only modify the date for all the rows that are dated <code>06-FEB-12</code> to <code>25-JAN-12</code> preserving the time. </p>
  
  <p>Can I do the same through an update query?</p>