Horton

Re: datestyle

Thomas Lockhart <lockhart@alumni.caltech.edu>

View thread
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: bruno.leveque@libertysurf.fr, pgsql-bugs@postgresql.org
Date: 2000-09-11T14:49:30Z
Lists: 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