select OrderID, OrderDate,
  datediff(yy, '2018-01-01', OrderDate) as Year,
  datediff(qq, '2018-01-01', OrderDate) as Quarter,
  datediff(m, '2018-01-01', OrderDate) as Month,
  datediff(d, '2018-01-01', OrderDate) as Day,
  datediff(dw, '2018-01-01', OrderDate) as DayOfWeek
from Orders