title: splitting a datetime column into year, month and week
body: <p>I want to split a datetime column so that the year and the month both have their own column in a select statement output. I also want to have a column by week of the year, as opposed to specific date. </p>
  
  <p>Basically, I want separate year, month, and week columns to show up in my select statement output. </p>