title: Converting DateTime format of Excel into DateTime Pandas
body: <p>From a query executed with Microsoft SQL Server, I have exported a csv file i would like to load into a data frame with pandas. Here I have some columns which contain date time values. In Microsoft SQL the date time values are normally presented. However, when exported to csv, the date time values change to I think a float. Here is a sample:</p>
  
  <pre class="lang-none prettyprint-override"><code>        DateTime 1      Datetime 2   
          20/04/16 07:15  13:00.0
          15:00.0         13:00.0
          15:00.0         13:00.0
          15:00.0         13:00.0
          15:00.0         13:00.0
          15:00.0         13:00.0
          15:00.0         13:00.0
          15:00.0         13:00.0
          15:00.0         13:00.0
  </code></pre>
  
  <p>In the first row you see the date time value that is behind the integer. It 'comes to light' when i enter the cell in excel and press enter... When i load this into pandas with read_csv, the 15:00.0 is loaded and not the 20/04/16 07:15.</p>
  
  <p>I tried to change the column to datetime using xrld package of Python, unfortunately it did not have the expected output. </p>
  
  <p>What kind of format is this exactly and is it possible to write code to automate the conversion of the datetime columns?</p>