Live2D

sql 根据身份证号码计算年龄

 

select PersonalId ,FLOOR(DATEDIFF(DY, substring(PersonalId,7,4), GETDATE()) / 365.25) from ConstructionInfo

 

posted @ 2019-04-19 14:42  webmtjj  阅读(3084)  评论(0)    收藏  举报