How Can I Calculate the Difference Between Two Dates in MySQL?

Calculating Date Difference in MySQL

In MySQL, determining the number of days between two dates can be achieved using the DATEDIFF function.

How it Works:

The DATEDIFF function takes two expressions as arguments, typically dates or date-and-time expressions. The function subtracts the second expression from the first and returns the difference as a value in days. Only the date parts of the values are used in the calculation.

Example Scenario:

Consider the following scenario:

• Check-in date: 12-04-2010
• Check-out date: 15-04-2010

Applying the DATEDIFF Function:

To calculate the day difference in this scenario, use the following query:

SELECT DATEDIFF('2010-04-15', '2010-04-12');

Interpreting the Result:

The result of the query will be:

| datediff('2010-04-15', '2010-04-12') |
|--------------------------------------|
|                                    3 |

This indicates that there is a day difference of 3 days between the two dates.

Note:

It's important to ensure that the dates are written in the YYYY-MM-DD format, as specified in the DATEDIFF function syntax. Dates written in other formats may return incorrect results.

The above is the detailed content of How Can I Calculate the Difference Between Two Dates in MySQL?. For more information, please follow other related articles on the PHP Chinese website!