How to sort date from past to present
Posted: Wed Dec 02, 2009 1:11 am
I wishes my data will show according to the date, but no matter how i try, it cannot be!
I am using this code:
The result shows as:
I am using this code:
Code: Select all
SELECT * FROM customer ORDER BY date DESCActually I wishes my result show as:1 Jacky 30.11.2009
2 Willy 02.12.2009
3 Jason 01.12.2009
1 Willy 02.12.2009
2 Jason 01.12.2009
3 Jacky 30.11.2009