title: How to convert string to datetime without days in pandas
body: <p>For example <code>issue_d</code> column in dataframe is string, <code>df['issue_d'] = 'Dec-2012'</code></p>
  
  <p>I want to convert the string to datetime type not string type: <code>2012-12</code>, how to do that?</p>
  
  <p>I use </p>
  
  <pre><code>[datetime.strptime(x, '%b-%Y') for x in df.issue_d]
  </code></pre>
  
  <p>But I get as result 2012-12. </p>
  
  <p>How can I get a result without days, and save it into a database by using mysql and sqlalchemy? I create a column issue_d with DateTime() type in my database.
  I want to insert the df['issue_d'] into that table.</p>
  
  <p><a href="https://i.stack.imgur.com/LKk9N.png" rel="nofollow noreferrer">Table created using sqlalchemy</a></p>