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

SHARE THIS PAGE

COLOR PICKER

colorpicker





Search w3schools.com:

Translate w3schools.com: