MSSQL 语句转 MYSQL 求帮忙

[yejian520]

以前一直用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？

[ACMAIN_CHM]

select SUM(Vendite_List.TotRighe) as vq,date_format(Data,'%Y-%m-%d') 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 date_format(Data,'%Y-%m-%d')

[weishaolin13x]

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