I want to store date in my database table in dd/mm/yy format & perform order by on that column.

Question

I want to store date in my database table in dd/mm/yy format & perform order by on that column. Please help.

Answer 1

A date field is not stored in any particular human readable format, rather that is how it is formatted when printed/displayed. ORDER BY will properly sort a date/datetime column regardless of how you may want it formatted for display.