MySQL ORDER BY messed up?

I am pulling the following results from MySQL
655617600
1180454612
1180454516
1180454322

And that is how they ordered it when I did:
ORDER BY date DESC

Clearly "655617600" is smaller than "1180454322"
How do I rectify this?

 

what is your field type?

 

it was varchar, now it is int and it works correctly
thanks a bunch

 

FYI: If you need that sorting on varchar fields, cast it to unsigned.
Example:
select cast("123" as unsigned)
or
select yourfieldname from yourtable order by cast(yourfieldname as unsigned)