I have One Column in the Mytable called StockDate and its DataType is DateTime.

So My Table contains record as follows

    SID                StockDate
   -----              ------------
     1                 2011-10-02 09:44:41.170
     2                 2011-10-02 09:48:23.234

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.

sql sql-server sql-server-2005 datetime
Edit
Report