title: pandas read_sql to return last row's date
body: <p>I'm trying to use pandas to read_sql table and return only the last date to me.</p>
  
  <pre><code>pandas.read_sql('sqltable', con=engine)['Date'].tail(1)
  </code></pre>
  
  <p><strong>this returns</strong></p>
  
  <pre><code>#Index # Date
  2589   2016-03-07
  Name: Date, dtype: datetime64[ns]
  </code></pre>
  
  <p>But If I do this:</p>
  
  <pre><code>pandas.read_sql('sqltable', con=engine)['Date'].ix[0]
  </code></pre>
  
  <p><strong>it returns</strong></p>
  
  <pre><code># Starting Date     # Time stamp
  2012-08-23          00:00:00
  </code></pre>
  
  <p>How can I just get it to show me <code>2016-03-07</code> and nothing else? I tried combining <code>.tail(1).ix[0]</code> together but it gives me an error instead. </p>
  
  <p>How should I do this? </p>