DATE FUNCTION

Syntax:
DATE(expr)

Extracts the date part of the date or datetime expression expr.