SQL日月年转换年月日
方法比较砍,请高手赐教!
--第一步查出日期在前且不包含0的 修改添加0
select elder_name,birthrate as olddate,'0'+birthrate as newdate from t_elder_base_info where birthrate!='' and substring(birthrate,2,1)='-' update t_elder_base_info set birthrate = '0'+ birthrate where birthrate!='' and substring(birthrate,2,1)='-'
?
--第二步查询出日期在前面的 修改至后面 (日月年修改为年月日格式)
select elder_name,birthrate as olddate,substring(birthrate,7,4)+substring(birthrate,3,3) +'-'+substring(birthrate,1,2) as newdate from t_elder_base_info where birthrate!='' and substring(birthrate,3,1)='-' update t_elder_base_info set birthrate = substring(birthrate,7,4) + substring(birthrate,3,3) + '-'+substring(birthrate,1,2) where birthrate!='' and substring(birthrate,3,1)='-'
?
?
