UPDATE bd_transport_drivers set birthday = STR_TO_DATE(CONCAT_WS("-",SUBSTRING(SUBSTRING(ID_NUM, 7, 8),1,4),SUBSTRING(SUBSTRING(ID_NUM, 7, 8),5,2),SUBSTRING(SUBSTRING(ID_NUM, 7, 8),7,2)), '%Y-%m-%d')
mysql 截取字段串字段转换成时间格式
最新推荐文章于 2024-05-23 20:16:10 发布