sql 语句

1.替换字段中得字符

SELECT REPLACE('2019-06','-','')      结果201906

实例 select  REPLACE(a.create_date,'-','')  from user