Latest web development tutorials
 

MySQL DATE() Function


< 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 2014-11-22 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 Cheese2014-11-22

< MySQL Date Functions