Re: Sort by foreign date column - Mailing list pgsql-general

omid omoomi wrote:
>
> and how about this:
>
> SELECT TO_CHAR(chdate, 'DD-MM-YYYY')
> FROM mytable
> ORDER BY chdate::date;

Yes, but Andrey says that the chdate field is declared as a date:

> > > > On Tue, 21 Aug 2001, Andrey Y. Mosienko wrote:
> > > >
> > > > >
> > > > > I have table with date type column:
                            ^^^^
> > > > >
> > > > > chdate date;

so if that is the case, something is broken.

Mike Mascari
mascarm@mascari.com