Posted by Chris Lott on 12/21/05 23:47

On 12/21/05, Ross <ross@aztechost.com> 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

• Next in forum: Re: [PHP] HTML rendering extension?
• Prev in forum: Re: [PHP] HTML rendering extension?
• Thread view: Re: [PHP] sorting dates with php

[Reply to this message]