DATE() in MySQL
The DATE() function is used to extract the date part from a DateTime expression. This function is an inbuilt function in MySQL. The DATE() function in MySQL can be used to know the date for a given date or a DateTime. The DATE() function takes a date value as an argument and returns the date. The date argument represents the valid date or DateTime.
- Parameter : It accepts only one parameter.
- Expression : It represents the date/datetime value.
- Return Value : It returns the date and returns NULL if the expression is not a date.
Syntax
select date('Expression');
Examples of DATE()
Below are some common examples or usages of the DATE() function :
- Example-1: Extracting date from a given date.
Select DATE('2020-06-23');
Output :
2020-06-23
- Example-2: Extracting date from a given DateTime.
Select DATE("2020-06-23 10:34:29");
Output :
2020-06-23
- Example-3: Extracting date from a given date.
SELECT DATE("The date is 2020-06-23");
Output :
NULL