How to Extract Only the Date Component from a DATETIME Field in MySQL?

How to Isolate the Date Component from a DATETIME Field in MySQL

When dealing with DATETIME fields in MySQL, there are instances where extracting only the date component becomes necessary. Whether for data analysis, reporting, or filtering purposes, isolating the date can be crucial.

Question:

How can I perform a SELECT query in MySQL that retrieves only the date portion from a DATETIME field, disregarding the time component, even if the column is defined as DATETIME?

Answer:

To achieve this, the DATE() function in MySQL comes into play. By utilizing this function, you can effectively extract the date component from a DATETIME field, excluding any time information.

Syntax:

SELECT DATE(ColumnName) FROM TableName;

Example:

Consider a DATETIME field named "timestamp" in a table called "events." To select only the date component from this field, you would use the following query:

SELECT DATE(timestamp) FROM events;

Output:

This query would return results that include only the date portion of the "timestamp" column, in the following format:

yyyy-mm-dd

Additional Notes:

The MySQL DATE() function converts a DATETIME or TIMESTAMP value to a date value, discarding any time information. This is particularly useful when working with historical data or when comparing dates across different time zones.

The above is the detailed content of How to Extract Only the Date Component from a DATETIME Field in MySQL?. For more information, please follow other related articles on the PHP Chinese website!