I am fairly new to MySQL and have a table containing a 'DATE' column, there is no time portion.
The data in the column is in the format 'YYYY-MM-DD'
I am trying to select rows displaying the date as 'MM-DD-YYYY'
and also order by this date field but the results are not ordering correctly, I have tried using the following statement:
select date_format(incomeDate, '%m-%d-%Y') from income order by date_format(incomeDate, '%m-%d-%Y');
but I'm getting results like:
Obviously these are not in date order
please help :)