sql current date without time mysql code example

Example: mysql date without time

SELECT date(my_date)