SQL日月年转换年月日

最新推荐文章于 2024-08-02 04:04:48 发布

Tony918

最新推荐文章于 2024-08-02 04:04:48 发布

阅读量3k

点赞数

分类专栏： SQLServer 文章标签： SQL 日月年年月日

本文链接：https://blog.csdn.net/YTWY001/article/details/84088311

版权

SQLServer 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

方法比较砍,请高手赐教!

--第一步查出日期在前且不包含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)='-'