Mysql strip time component from datetime
Solution 1:
Yes, use the date function:
SELECT date(my_date)
Solution 2:
select date(somedate) is the most common.
If you need to accommodate other formats, you can use:
SELECT DATE_FORMAT(your_date, '%Y-%m-%d');