[SOLVED] Possible to order MySQL Results by this type of date format: 3/1/1999 ?

[suttercain]

Hi guys,

 

I think the title asks the question I am seeking an answer for. The database stores dates in a 1/5/1995 format (month/day/year)

 

Can I have the results ORDER BY coverdate?

 

Thanks,

 

SC

[snk]

of course you can, if you want to reverse the order of result use the DESC at the end of your query

e.g    ..ORDER by f_date DESC;

[suttercain]

I got it...

 

$query = mysql_query("SELECT *, STR_TO_DATE(cover_date,'%d/%m/%Y') as Mydate FROM comics WHERE title = '".mysql_real_escape_string($search)."' AND type ='Comic Book' ORDER BY Mydate") or die(mysql_error());

[snk]

ouchhh ok, sorry i thought you wanted to order the data...

thanks for replying the solution