title: Passing chopped down datetimes
body: <p>I have been stumped for the past few hours trying to solve the following.</p>
  
  <p>In a large data set I have from an automated system, there is a DATE_TIME value, which for rows at midnight has values that dont have a the full hour like: <em>12-MAY-2017  0:16:20</em></p>
  
  <p>When I try convert this to a date (so that its usable for conversions) as follows:</p>
  
  <pre><code>df['DATE_TIME'].astype('datetime64[ns]')
  </code></pre>
  
  <p>I get the following error: </p>
  
  <pre><code>Error parsing datetime string "12-MAY-2017  0:16:20" at position 3
  </code></pre>
  
  <p>I tried writing some REGEX to pull out each piece but couldnt get anything working given the hour could be either 1 or two characters respectively. It also doesn't seem like an ideal solution to write regex for each peice.</p>
  
  <p>Any ideas on this?</p>