From http://www.w3schools.com (Copyright Refsnes Data)

MySQL DATE() Function

SQL Dates MySQL Date Functions

Definition and Usage

The DATE() function extracts the date part of a date or date/time expression.

Syntax

DATE(date)

Where date is a valid date expression.

Example

Assume we have the following "Orders" table:

OrderId ProductName OrderDate
1 Jarlsberg Cheese 2008-11-11 13:23:44.657

The following SELECT statement:

SELECT ProductName, DATE(OrderDate) AS OrderDate
FROM Orders
WHERE OrderId=1

will result in this:

ProductNameOrderDate
Jarlsberg Cheese2008-11-11

SQL Dates MySQL Date Functions

From http://www.w3schools.com (Copyright Refsnes Data)