i have written following query
select * from lab_info order by p_date DESC
this query executed successfully and retured all rows but problem is that last inserted record which should be seen first.
but it shows in the middle of rows.
i have inserted record in "dd/MM/yyyy" format.
for exp:
result like this
p_date
------
24/06/2015
15/07/2015
06/07/2015
here in above sequence of record 24/06/2015 should be last in as per query result but it shows on first position please give solution for this.