[PHP-DB] ordering date in varchar
We have a problem. We have given the dates as date.month.year eg 27.12.2007 The field is named as varchar. We have to arrange ths list of dates in ascending order. Can anyone help? Varchar arranges the list by scanning from left side. Perhaps scanning from right side will do. How to do it? -- Vaibhav Informatics, 109 Vasant Plaza, Munirka, Near Subway, New Delhi-110 067 Ph: 011-26194466 Email :[EMAIL PROTECTED]
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 PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] ordering date in varchar We have a problem. We have given the dates as date.month.year eg 27.12.2007 The field is named as varchar. We have to arrange ths list of dates in ascending order. Can anyone help? Varchar arranges the list by scanning from left side. Perhaps scanning from right side will do. How to do it? -- Vaibhav Informatics, 109 Vasant Plaza, Munirka, Near Subway, New Delhi-110 067 Ph: 011-26194466 Email :[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 PROTECTED]; [EMAIL PROTECTED] > Subject: [PHP-DB] ordering date in varchar > > We have a problem. We have given the dates as date.month.year eg 27.12.2007 > The field is named as varchar. We have to arrange ths list of dates in > ascending order. Can anyone help? Varchar arranges the list by scanning from > left side. Perhaps scanning from right side will do. How to do it? > > For the best functionality and performance you should use date fields for your database. -- Isaak Malik Web Developer [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php