RE: [PHP] Re: sort by date

as of MySQL 4.1.1. -Original Message- From: William Stokes [mailto:[EMAIL PROTECTED] Sent: 06 May 2005 08:23 To: php-general@lists.php.net Subject: [PHP] Re: sort by date Ok tested this and it won't work. Next question is sql question but anyway... Can I use STR_TO_DATE() or GET_F

[PHP] Re: sort by date

Ok tested this and it won't work. Next question is sql question but anyway... Can I use STR_TO_DATE() or GET_FORMAT(DATE,'EUR') to query and sort dates to web page as a date even if the data is just a string in the db? Probably with GET_FORMAT(DATE,'EUR') it wont work cause it's a varchar fiel