MySQL DATE_ADD() 函数
语法:
DATE_ADD(date,INTERVAL expr type)
实例:
SELECT OrderId,DATE_ADD(OrderDate,INTERVAL 2 DAY)
AS OrderPayDate FROM Orders
(向 "OrderDate" 添加 2 天)
DATE_ADD(date,INTERVAL expr type)
SELECT OrderId,DATE_ADD(OrderDate,INTERVAL 2 DAY)
AS OrderPayDate FROM Orders
(向 "OrderDate" 添加 2 天)