MySQL DATEDIFF Function: Examples

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

customers

SELECT * FROM customers;

employees

SELECT * FROM employees;

offices

SELECT * FROM offices;

orderdetails

SELECT * FROM orderdetails;

orders

SELECT * FROM orders;

payments

SELECT * FROM payments;

productlines

SELECT * FROM productlines;

products

SELECT * FROM products;

Result