Please !!! MYSQL!! how to order by DESC or ASC with 12-07-2007(dd-mm-yyyy hh:mm:ss)

[slackman]

MYSQL!! how to order by DESC or ASC with 12-07-2007 10:00:00 (dd-mm-yyyy hh:mm:ss)

i store dat-time in birthday filed with varchar type and store data format 12-07-2007(dd-mm-yyyy hh:mm:ss) and try to query order by desc or asc not working

How to

1. my field store date-time that varchar and (dd-mm-yyyy hh:mm:ss) only

[bigtomrodney]

You should consider changing that field data type. The date format is valid for youse with datetime.

In the meantime -

select cast($columname As DateTime) "Time" order by 1 desc

Where $columname is your varchar column you want as datetime, "Time" is an alias you are giving it and it is ordered descending by column 1 (out of one column).