Datepart below is suitable using in DATEADD, DATEDIFF, DATENAME and all Date related function.
| Datepart | Abbreviations |
|---|---|
| Year | yy, yyyy |
| quarter | qq, q |
| Month | mm, m |
| dayofyear | dy, y |
| Day | dd, d |
| Week | wk, ww |
| Hour | hh |
| minute | mi, n |
| second | ss, s |
| millisecond | ms |
powered by www.pHick1.com