Sort by foreign date column

From: "Andrey Y(dot) Mosienko" <feo(at)ttn(dot)ru>
To: Postgres <pgsql-general(at)postgresql(dot)org>
Subject: Sort by foreign date column
Date: 2001-08-21 04:48:57
Message-ID: 3B81E839.CC622170@ttn.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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?

--
with respection Andrey Feofilactovich.
e-mail: feo(at)ttn(dot)ru, feo(at)feo(dot)org(dot)ru
ICQ: 28073807

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-08-21 05:30:07 Re: Re: is this possible? it should be!
Previous Message will trillich 2001-08-21 04:33:46 not grokking outer joins...