SQL Function Reference

Retrieves the date from a date and time of day value in YYYY-MM-DD HH:MM:SS format, truncating hours, minutes, and seconds

DATE(datetime)

SELECT DATE("2022-12-05 10:37:22");