title: How to update only "hour" part in a datetime field in oracle?
body: <p>Is there a way to update only Hour part in a DateTime field?? If not, how do I update the time part in Oracle? I tried this-></p>
  
  <pre><code>update tab_name 
  set C_Name=to_date('04/03/2012 00:31:00','MM/DD/YYYY HH:MI:SS AM') 
  where C_Name1=10484;  
  </code></pre>
  
  <p>didn't work as I'm updating '00' in Hour part.</p>