Open In App

DATE() in MySQL

Improve
Improve
Like Article
Like
Save
Share
Report

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
Previous
Next
Share your thoughts in the comments
Similar Reads