CREATE VIEW VI_Lend
AS
SELECT TBL_BorrowInfo.BookID,BookName,Publisher,BorrowDate,
DateAdd("m",1,BorrowDate) AS ShouldReturnDate
FROM TBL_BorrowInfo LEFT OUTER JOIN TBL_BookInfo
ON (TBL_BorrowInfo.BookId = TBL_BookInfo.BookID)--为了实现将ShouldReturnDate就是BorrowDate的时间加上1个月,可是我实现不了
--我觉得应该是DateAdd里面的第三个参数错了,应该是字符串类型,可是我不知道怎么将
--DateTime转换为字符串
AS
SELECT TBL_BorrowInfo.BookID,BookName,Publisher,BorrowDate,
DateAdd(mm,1,BorrowDate) AS ShouldReturnDate
FROM TBL_BorrowInfo LEFT OUTER JOIN TBL_BookInfo
ON (TBL_BorrowInfo.BookId = TBL_BookInfo.BookID)
AS
SELECT TBL_BorrowInfo.BookID,BookName,Publisher,BorrowDate,DateAdd(mm,1,BorrowDate) AS ShouldReturnDate
FROM TBL_BorrowInfo LEFT OUTER JOIN TBL_BookInfo
ON (TBL_BorrowInfo.BookId = TBL_BookInfo.BookID)
/*
-----------------------
2010-07-04 17:23:58.513(1 行受影响)
*/函数测试正常
/*
-----------------------
2010-07-04 17:23:58.513(1 行受影响)
*/其实这样也可以