Re: [PHP-DB] ordering date in varchar

> I think you can try the SQL: > Select STR_TO_DATE([field_name], '%d/%m/%Y') as newDate , [field_name] from > [table] order by newDate asc; > > Thanks, > Haitao > > > -Original Message- > From: Vaibhav Informatics [mailto:[EMAIL PROTECTED] > Sent: 2008年3月13日 16:36 > To: php-db@lists.p

RE: [PHP-DB] ordering date in varchar

I think you can try the SQL: Select STR_TO_DATE([field_name], '%d/%m/%Y') as newDate , [field_name] from [table] order by newDate asc; Thanks, Haitao -Original Message- From: Vaibhav Informatics [mailto:[EMAIL PROTECTED] Sent: 2008年3月13日 16:36 To: php-db@lists.php.net; [EMAIL PROTECTE