Question

如何在SQLserver2008 R2中写update语句在表的列中修改日期格式

如将图片中整列所有日期格式修改为2009-03-25类型的格式，求大神指导！

Answer 1

update tablename set fzhrq = convert(varchar(10), convert(datetime, replace(fzhrq, '/', '-')), 121)
update tablename set fzhrq = convert(varchar(10), convert(datetime, replace(fzhrq, ' ', '-')), 121)
试下看看了.两句后面都加个Where条件吧
Where fzhrq <> ''