Re: Sort by foreign date column

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(at)ttn(dot)ru, feo(at)feo(dot)org(dot)ru
ICQ: 28073807