Difference between datediff in access and SQL Server

Syntax

Datediff (interval, date1, date2[, Firstdayofweek] [, Firstweekofyear])

 

The difference is whether interval should be enclosed in quotation marks;

Access: datediff ('n', lastactivetime, '"+ datetime. Now +"')> = 10

SQL Server:Datediff (n, lastactivetime, '"+ datetime. Now +"')> = 10

IntervalParameters(Parameter: the value that provides information for operations, events, methods, attributes, functions, or processes .)Includes the following settings:

Set	Description
Yyyy	Year
Q	Quarter
M	Month
Y	One day of a year
D	Days
W	Workday
WW	Week
H	Hour
N	Minute
S	Seconds

Parameters
Year
Yyyy

Quarter
Q

Month
M

Day of year
Y

Day
D

Weekday
W

Week
WW

Hour
H

Minute
N

Second
S