DateDiff
datepart
|
Analytics
|
MS-SQL
|
J-SQL
|
year
|
yy, yyyy
|
yy, yyyy
|
yyyy
|
quarter
|
qq, q
|
qq, q
|
q
|
month
|
mm, m
|
mm, m
|
m
|
dayofyear
|
dy, y
|
dy, y
|
y
|
day
|
dd, d
|
dd, d
|
d
|
Weekday
|
dw, w
|
w
|
|
week
|
wk, ww
|
wk, ww
|
ww
|
hour
|
hh
|
hh
|
h
|
minute
|
mi
|
mi, n
|
n
|
second
|
ss, s
|
ss, s
|
s
|
millisecond
|
ms
|
ms
|
|
microsecond
|
mcs
|
mcs
|
|
nanosecond
|
ns
|
Wildcards:
Description
|
MS-SQL
|
Jet SQL
|
Any String of zero or more characters
|
%
|
*
|
Match one character
|
_(underscore)
|
?
|
No comments:
Post a Comment