以前一直用MSSQL,现在转到MYSQL,版本是5.6.29请热心人帮我转一条SQL语句select SUM(Vendite_List.TotRighe) as vq,convert(varchar(10),Vendite_List.Data,120) as rq from Vendite_List where Vendite_List.DATA between '2016-02-26 00:00:00' and '2016-03-17 23:59:59' group by convert(varchar(10),Vendite_List.Data,120) order by rq 怎么转成MYSQL?
dite_List.DATA between '2016-02-26 00:00:00' and '2016-03-17 23:59:59.999'日期格式化 date_format(a.CreateTime,'%Y-%m-%d') as name
from Vendite_List
where Vendite_List.DATA between '2016-02-26 00:00:00' and '2016-03-17 23:59:59'
group by date_format(Data,'%Y-%m-%d')