SQL Server - Cambiar consulta Mysql en SQL Server

SELECT

s.qty, DATE_FORMAT(s.date, '%Y-%m-%e') AS date,

p.name,SUM(p.sale_price * s.qty) AS total_saleing_price

FROM sales s LEFT JOIN products p

ON s.product_id = p.id

WHERE DATE_FORMAT(s.date, '%Y' ) = '2017'

GROUP BY DATE_FORMAT( s.date,  '%c' ), s.product_id

ORDER BY date_format(s.date, '%c' ) ASC