title: Android/java Sqlite: How to retrieve max datetime?
body: <p>Below is the snapshot of what I have got as a query from sqlite db.</p>
  
  <p>After googling and reading a number of question around, I have come to know that to retrieve maximum datetime using aggregate functions like <code>max()</code> is not possible as sqlite doesn't support much datatypes but treats datatype as <code>text</code>.</p>
  
  <p>So, I have brought this data in a <code>List</code> or at <code>java</code> level. So how could I now get the maximum datetime from this list.</p>
  
  <blockquote>
    <p>Is there any direct construct for this format in java. Or do we have something at sqlite level that I coudn't find.</p>
  </blockquote>
  
  <p><img src="https://i.stack.imgur.com/ZoWvK.png" alt="Sqlite returned data"></p>