Page 1 of 1

How to sort a varchar field with "/"

Posted: Wed Dec 28, 2011 6:50 pm
by stevenh
I have a varchar field called date that looks like this "2/06/2011 TUE" or like this "10/05/2011 WED".
When I do an Order BY date Desc in php it does Not sort properly.
Thanks for your assistance

Steve

Re: How to sort a varchar field with "/"

Posted: Wed Dec 28, 2011 11:40 pm
by s.dot
You could try ORDER BY UNIX_TIMESTAMP(date) DESC
Or some other mysql date/time functions