Re: datestyle - Mailing list pgsql-bugs

From Thomas Lockhart
Subject Re: datestyle
Date
Msg-id 39BCF0FA.B042F237@alumni.caltech.edu
Whole thread Raw
In response to datestyle  (pgsql-bugs@postgresql.org)
List pgsql-bugs
> I cannot change the format of the date style with set
> ... I want to use the European format i.e : DD/MM/YYYY and not YYYY/MM/DD...
> NOTICE:  DateStyle is ISO with European conventions
> SHOW VARIABLE

The ISO style is YYYY/MM/DD. The "European conventions" in this case
only affect the interpretation of ambiguous *input*.

You need to specify "Postgres,European" as your date style.

                    - Thomas

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: nested implicit selects (views) go wrong
Next
From: Lamar Owen
Date:
Subject: Re: [SQL] Re: "ORDER BY" issue - is this a bug?