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(at)mascari(dot)com