sort date fields to obtain earliest date
<p>in my database , dates are stored in DD-mm-yyyy format , how can i sort this to obtain the earliest date ? </p>

<pre><code>Cursor c = myDb.query(TABLE, new String[]{"dob"}, null, null, null, null, "dob");
</code></pre>

<p>I have selected it to order by dob field but its not ordered ...
This is the output for the above query</p>

<pre><code>01-03 17:14:51.595: VERBOSE/ORDER DOB(1431): 01-11-1977
01-03 17:14:51.595: VERBOSE/ORDER DOB(1431): 01-12-1988
01-03 17:14:51.614: VERBOSE/ORDER DOB(1431): 15-01-1977
01-03 17:14:51.656: VERBOSE/ORDER DOB(1431): 31-01-1988
</code></pre>
