Datepart Options And Abbreviations
The following table lists the datepart options and abbreviations recognized by SQL Server Compact 3.5.
Datepart |
Abbreviations |
Year |
yy, yyyy |
quarter |
qq, q |
month |
mm, m |
dayofyear |
dy, y |
day |
dd, d |
week |
wk, ww |
weekday* |
dw |
hour |
hh |
minute |
mi, n |
second |
ss, s |
millisecond |
ms |
Excellent post. I’ll back here soon.