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

> On Tue, 21 Aug 2001, Andrey Y. Mosienko wrote:
> But in Russia we have the next date format: DD-MM-YYYY.

Just setting DateStyle to 'SQL' would get you approximately what you
want:

regression=# set DateStyle TO SQL;
SET VARIABLE
regression=# select now();
            now
----------------------------
 21/08/2001 10:07:04.00 EDT
(1 row)

regression=# select now()::date;
  ?column?
------------
 21/08/2001
(1 row)

If DD/MM/YYYY is not close enough for you, maybe the right answer is to
add another DateStyle.

            regards, tom lane