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.
Syntax :
select date('Expression');
- 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.
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
Last Updated :
06 Jul, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...