title: SQL- How to convert a YYYYMM number to a date
body: <p>So I'm pretty new to SQL and I have a column full of numbers that list year and month in YYYYMM format (i.e. 201607 for July 2016). What I'd like to know is if I can convert this into proper date format within SQL. I've done a fair bit of research and I've seen a lot of answers regarding converting YYYYYMMDD form to a date, but not much with only the 6 characters I've got.</p>
  
  <p>Anybody got any ideas?</p>