http://topic.csdn.net/u/20071221/10/c4b18779-6b41-49e6-ab2c-8df6db82d069.html?seed=1755921428&r=55771563#r_55771563
请看4楼
是批量修改的2006-1-05 0:10:00 改成 2010-10-8 00:10:00
请看4楼
是批量修改的2006-1-05 0:10:00 改成 2010-10-8 00:10:00
FROM table1
或
SELECT FormatDateTime(theDate, 2) AS 日期部分
FROM table1
insert into #a values ('2006-1-05 00:10:00')
insert into #a values ('2007-5-05 00:10:00')
update #a set dd=dateadd(yy,2008-datepart(yy,dd),dd)
select * from #a
drop table #a