Re: Sort by foreign date column

Stephan Szabo wrote:
>
> On Tue, 21 Aug 2001, Andrey Y. Mosienko wrote:
>
> >
> > I have table with date type column:
> >
> > chdate date;
> >
> > SELECT chdate from mytable;
> >
> >    chdate
> >  1999-01-02
> >
> > But in Russia we have the next date format: DD-MM-YYYY.
> >
> > When I do coversion to char in SELECT:
> > TO_CHAR(chdate,'DD-MM-YYYY') everything is ok, but sort by this column
> > executes as sort for char type.
> >
> > How can I display my native date format and do right sorting by this column?
>
> Wouldn't
> select to_char(chdate, 'DD-MM-YYYY') from mytable order by chdate;
> work?

Works. But sorting performs as for CHAR TYPE!

--
with respection Andrey Feofilactovich.
e-mail: feo@ttn.ru, feo@feo.org.ru
ICQ: 28073807