CODE EXAMPLE FOR SQL

mysql datetime to date

Use DATE(). Here is an example from https://www.w3schools.com/sql/func_mysql_date.asp 

SELECT DATE("2017-06-15 09:34:21"); // returns 2017-06-15