title: SQL Date, Flagging, Hive
body: <p>I have a table with dates in this format "12/14/2017" and I want to create another column that separates month from this date string and states it like "January" not "01". I think I need a mix of CASE function with some kind of DATE function. </p>
  
  <p>Table:</p>
  
  <pre><code>Column A   
  12/14/2017
  12/11/2017
  2/16/2018
  1/2/2017
  </code></pre>
  
  <p>Output I need which I will Column B:</p>
  
  <pre><code>Column A    Column B (Output)
  12/14/2017  December
  12/11/2017  December
  2/16/2018   February
  1/2/2017    January
  </code></pre>