Mahmoud ElMansy: knowledge meant to be free

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