title: How to get month and year from date in SQL
body: <p>I need help to get month and year from a date which is in yyyymmdd format.</p>
  
  <p>The dates look like this, '20150102', the output should be Jan 2015.</p>
  
  <p>I want the output as on single value, currently using datepart function Im getting output in 2 different columns for month and year</p>