select OrderID, OrderDate,
  dateadd(yy, 1, OrderDate) as Year,
  dateadd(qq, 2, OrderDate) as Quarter,
  dateadd(m, 3, OrderDate) as Month,
  dateadd(d, 4, OrderDate) as Day,
  dateadd(dw, 5, OrderDate) as DayOfWeek
from Orders