need to convert sql server query to mysql query

I've need to convert following sql server query into mysql

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, p_date)) [date],
       SUM(p_amount) [sum]
FROM tbl_Payments
WHERE DATEADD(dd, 0, DATEDIFF(dd, 0, p_date)) BETWEEN '20130701' AND '20130731'
GROUP BY DATEADD(dd, 0, DATEDIFF(dd, 0, p_date))

column names: p_date,p_amount

Copyright Notice：Content Author:「Ratheesh Zachariah」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/25286890/need-to-convert-sql-server-query-to-mysql-query