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: 167
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