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.

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 

Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced 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 contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. 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 contribute@geeksforgeeks.org to report any issue with the above content.