CODE EXAMPLE FOR SQL

how to get the date from datetime in mysql

SELECT DATE(ColumnName) FROM tablename;