select OrderID, OrderDate,
  Datename(yy, OrderDate) as Year,
  Datename(qq, OrderDate) as Quarter,
  Datename(m, OrderDate) as Month,
  Datename(d, OrderDate) as Day,
  Datename(dw, OrderDate) as DayOfWeek
from Orders