Returns the number of days between two dates.
Syntax
DATEDIFF(d1, d2)Example
Enter values below to update the example in real time.
order_id→delivered_at→order_date→delivery_days→orders→-- 주문 후 배송까지 걸린 일수
SELECT order_id, DATEDIFF(delivered_at, order_date) AS delivery_days
FROM orders
WHERE delivered_at IS NOT NULL;