SELECT
CAST(DATE_ADD(‘day’,1-day(current_date),current_date)as varchar(20))
也可以用concat和substr
select cast(concat(sustr(cuccrent_date,1,8),substr(‘01’,1,2)) as date)
select
concat(substr(format_datetime(date_add(‘day’,0,CURRENT_DATE),‘yyyyMMdd’),1,6),‘01’)
cast( concat(substr(date_format(date_add(current_date,-1),‘yyyy-MM-dd’),1,8),‘01’ )as varchar(10))