select distinct date not datetime mysql code example

Example: mysql select distinct date from timestamp

SELECT DISTINCT(DATE(<your_column>)) FROM <your_table>;