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 :

  • Example-2: Extracting date from a given DateTime.
    Select DATE("2020-06-23 10:34:29"); 

    Output :

  • Example-3: Extracting date from a given date.
    SELECT DATE("The date is 2020-06-23"); 

    Output :


Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using or mail your article to See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.

Article Tags :
Practice Tags :

Be the First to upvote.

Please write to us at to report any issue with the above content.