DateDiff在Access与Sqlserver中的差别:语法 DateDiff(interval, date1, date2 [ , firstdayofweek ] [ , firstweekofyear ] ) 差别在于interval是否要用引号； Access:DateDiff('n',lastActiveTime,' + DateTime.Now + ')=10 Sql server: