MariaDB DATEDIFF() Function

The MariaDB DATEDIFF() function returns the difference between two date/datetime values. The returned value is expressed in days and the time portion of date1 and date2 are ignored.

Syntax

DATEDIFF(date1, date2)

Parameters

Return Value

Returns the difference between two date/datetime values expressed in days.

Example 1:

The example below shows the usage of DATEDIFF() function.

SELECT DATEDIFF('2019-10-25', '2019-10-15');
Result: 10

SELECT DATEDIFF('2019-10-25 12:40:45', '2019-10-15 10:20:25');
Result: 10

SELECT DATEDIFF('2019-10-25 12:40:45.001234', '2019-10-15 10:20:25.001000');
Result: 10

SELECT DATEDIFF('2019-10-15', '2019-10-25');
Result: -10

SELECT DATEDIFF('2019-10-25 12:40:45', '2019-10-15');
Result: 10

Example 2:

Consider a database table called Orders with the following records:

To calculate the number of days taken to settle the deal, the following query can be used:

SELECT *, DATEDIFF(PaymentDate, OrderDate) AS SettlementDays
FROM Orders;

This will produce a result similar to: