格式:2021-11-29
select
date_format(create_time,"%Y-%m-%d") as create_time
from
tableName
格式:20211129
select
date_format(create_time,"%Y%m%d") as create_time
from
tableName
格式:2021-11-29
select
date_format(create_time,"%Y-%m-%d") as create_time
from
tableName
格式:20211129
select
date_format(create_time,"%Y%m%d") as create_time
from
tableName