Friday, November 6, 2015

SQL Notes

I'm starting a table of conversions.  Since I'm now working in 3 SQL dialects I need to keep them straight!

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