updating only date part from datetime in sql server 2000

Posted by user294146 on Stack Overflow See other posts from Stack Overflow or by user294146
Published on 2010-06-01T13:10:02Z Indexed on 2010/06/01 13:53 UTC
Read the original article Hit count: 161

hi Experts,

I have data in the table like the following.

col1                   col2                   col3
--------------------------------------------------------
6/5/2010 18:05:00   6/2/2010 10:05:00         Null
6/8/2010 15:05:00   6/3/2010 10:45:00       6/5/2010 11:05:00 
6/3/2010 15:05:00   Null                    6/7/2010 12:05:00 
6/1/2010 15:05:00   6/3/2010 10:45:00       6/1/2010 14:05:00 

what my requirement is I want to update the date of there columns with single date without disturbing the time. say for example I want to update the table data with 6/1/2010 where the field data is not null. please let me know the query for updating the table data.

thanks & regards,

murali

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql-server-2000