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

From Andrey Y. Mosienko
Subject Re: Sort by foreign date column
Date
Msg-id 3B83348F.9F7D312E@ttn.ru
Whole thread Raw
In response to Re: Sort by foreign date column  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Sort by foreign date column  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
>
> > 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.

Sorry for disturbing, but how can I do this or where is it in documentation?

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

pgsql-general by date:

Previous
From: newsreader@mediaone.net
Date:
Subject: Re: Postgres hangs during VACUUM (autocommit = false)
Next
From: Tom Lane
Date:
Subject: Re: Sort by foreign date column