title: How to Update the Date without changing its Time Using SQL Server?
body: <p>I have One Column in the Mytable called StockDate and its DataType is DateTime.</p>
  
  <p>So My Table contains record as follows</p>
  
  <pre><code>    SID                StockDate
     -----              ------------
       1                 2011-10-02 09:44:41.170
       2                 2011-10-02 09:48:23.234
  </code></pre>
  
  <p>Here I want to update Only the Date of the StockDate as "2011-09-30". But the time should be same as it is. How to do this? Please I need all your suggestions.</p>