sql中data类型更新报错

Question

update book
set BorrowDueDate = DATEADD(Month,1,BorrowDueDate)
where Book_id = 124 and BorrowerMemNo = 124;
BorrowDueDate是date类型
提示字段month不存在

Answer 1

 DATEADD(Month,1,BorrowDueDate)

应为：

 DATEADD(month,1,BorrowDueDate)