I have a table with a dates column that is formatted in MM-DD-YYYY format, as shown in SQL SELECT statements. I'm using Qspatilite (QGIS 1.8) and Spatialite GUI.
When I ORDER BY the date column it sorts by MM, then by DD, then finally by YYYY.
In other words, I get rows like this:
01/04/2004
01/24/1987
02/07/1994
03/17/1982
03/27/2009
...
12/29/1997
I understand that SQLITE doesn't enforce data types. Is there an easy way to convert the format to YYYYMMDD (so that I can sort by date) or do I need to manually parse the date myself?