mysql order by on varchar

Question

Hi in my table , there is columns called time ,

Field type varchar , value like HH:MM , 02-25 ,21-42,07-15

Can u tell me , how to do the order by desc ,

Regards Bharanikumar

Answer 1

select * from table_name order by column_name DESC;

where,

table_name is name of table and 
column_name is name of column in the table (independent of whatever the data-type)

Note:-for proper o/p Your datatype for the time column should be datetime

Answer 2

ORDER BY CreationDate ASC,CreationTime DESC

PROBLEM FIXED