distinct date in mysql without timestamp code example Example: mysql select distinct date from timestamp SELECT DISTINCT(DATE(<your_column>)) FROM <your_table>;