MySQL DATE() Function
 MySQL Date Functions
Definition and Usage
The DATE() function extracts the date part of a date or date/time expression.
Syntax
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:
| ProductName | OrderDate |
|---|
| Jarlsberg Cheese | 2008-11-11 |
MySQL Date Functions
 |
W3Schools' Online Certification Program
The perfect solution for professionals who need to balance work, family, and career building.
More than 4000 certificates already issued!
|
The HTML Certificate documents your knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).
| 
