how to get only date from table in mysql

SELECT  DATE(`date`)AS `date` FROM `order`;

this use for remove duplicate:

SELECT  DISTINCT(DATE(`date`))AS `date` FROM `order`