On 12/21/05, Ross <ross@xxxxxxxxxxxxx> wrote: > Hi, > > Have a load of dates in the format DD/MM/YY. Thet are stored as a VARCHAR on > a mysql DB. Couldn't you use cast() to cast the values first? Something like (untested): SELECT CAST(doc_date AS DATE) FROM papers ORDER BY doc_date DESC c -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
