How do I update the time in oracle sql?
<p>I need a query to update a time in an appointment date by keeping the date but changing the time.
For example</p>

<p>10-Feb-2016 09:00:00
and i  want to change it to  10-Feb-2016 10:00:00.</p>

<pre><code>Update Appointment
set vdate = '10:00:00'
where vdate= '10-Feb-2016'
</code></pre>

<p>I get the "0 row has been updated'. Not sure if i'm missing something.
Thanks in advance.</p>