How to get end of month date from a "YearMonth" varchar column?
<p>We have YearMonth VARCHAR(10) column and I am trying to create a date column which will give me last date of the month based on the YearMonth column. </p>

<pre><code>For Example:
201612 - 12/31/2016
201602 - 02/29/2016
201702 - 02/28/2017
</code></pre>