TABLE 1: Highlighted Output from Listing 2
Date Component DATEPART() DATENAME() Synonym Function
Year 2002 2002 YEAR(): 2002
YY 2002 2002 YEAR(): 2002
YYYY 2002 2002 YEAR(): 2002
Quarter 2 2 n/a
Month 4 April MONTH(): 4
DayOfYear 97 97 n/a
Day 7 7 DAY(): 7
Week 15 15 n/a
Weekday 1 Sunday n/a
Hour 20 20 n/a
Minute 27 27 n/a
Second 55 55 n/a
Millisecond 493 493 n/a