subject:"\[PHP\-DB\] ordering date in varchar"

Re: [PHP-DB] ordering date in varchar

2008-03-13 Thread Isaak Malik

] > 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 dat

RE: [PHP-DB] ordering date in varchar

2008-03-13 Thread Liu, Hai Tao (Taylor)

et; [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

[PHP-DB] ordering date in varchar

2008-03-13 Thread Vaibhav Informatics

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? -- Va