MySQL DATE_SUB()

SELECT OrderId,DATE_SUB(OrderDate,INTERVAL 2 DAY) AS OrderPayDate
FROM Orders

Leave a comment

About Michael Li

user-pic I blog issues resolved at work