MySQL DATEDIFF Function: Examples

Back Home

Examples
Sample Database

#1

SELECT DATEDIFF('2011-08-17','2011-08-17'); --  0 day

#2

SELECT DATEDIFF('2011-08-17','2011-08-08'); --  9 days

#3

SELECT DATEDIFF('2011-08-08','2011-08-17'); -- -9 days

#4

SELECT 
    orderNumber, DATEDIFF(requiredDate, shippedDate) daysLeft
FROM
    orders
ORDER BY daysLeft DESC;

#5

SELECT 
    orderNumber,
    DATEDIFF(requiredDate, orderDate) remaining_days
FROM
    orders
WHERE
    status = 'In Process'
ORDER BY remaining_days;

#6

SELECT 
    orderNumber,
    ROUND(DATEDIFF(requiredDate, orderDate) / 7, 2),
    ROUND(DATEDIFF(requiredDate, orderDate) / 30,2)
FROM
    orders
WHERE
    status = 'In Process';

Table List