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