用法:
date_format()函数用于以不同的格式显示日期/时间数据。
语句:
select date_format(Operation_Datetime,'%Y-%m-%d') as time,
count(*) as countNum from vvc_market_get_customer
group by date_format(Operation_Datetime,'%Y-%m-%d');
date_format()函数用于以不同的格式显示日期/时间数据。
select date_format(Operation_Datetime,'%Y-%m-%d') as time,
count(*) as countNum from vvc_market_get_customer
group by date_format(Operation_Datetime,'%Y-%m-%d');