DateDiff在Access与Sqlserver中的差别

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

语法

DateDiff(interval, date1, date2 [, firstdayofweek] [, firstweekofyear] )

差别在于interval是否要用引号；

Access:DateDiff('n',lastActiveTime,'" + DateTime.Now + "')>=10

Sql server:DateDiff(n,lastActiveTime,'" + DateTime.Now + "')>=10

interval 参数 （参数：为操作、事件、方法、属性、函数或过程提供信息的值。）包含以下设置：

参数
Year
yyyy

Quarter
q

Month
m

Day of year
y

Day
d

Weekday
w

Week
ww

Hour
h

Minute
n

Second
s