"select * from TABLA where campo_fecha = 2017-06-13"
"select * from TABLA where SUBSTRING (campo_fecha,1,10) = 2017-06-13"
SELECT DATE('2003-12-31 01:02:03');
SELECT CAST('2003-12-31 01:02:03' AS DATE);
SELECT CONVERT(DATE,'2003-12-31 01:02:03',102);