update h_cablejoint_1009_2013 set icjsj = dateadd(d, datediff(d, icjsj , '2013-8-12') ,icjsj) where datatime
between '2013/8/12 00:00:00' and '2013/8/12 23:45:00'
update h_cablejoint_1009_2013 set icjsj = dateadd(d, datediff(d, icjsj , '2013-8-12') ,icjsj) where datatime
between '2013/8/12 00:00:00' and '2013/8/12 23:45:00'