> 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