Skip site navigation (1) Skip section navigation (2)

Re: datestyle

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: bruno(dot)leveque(at)libertysurf(dot)fr, pgsql-bugs(at)postgresql(dot)org
Subject: Re: datestyle
Date: 2000-09-11 14:49:30
Message-ID: 39BCF0FA.B042F237@alumni.caltech.edu (view raw or flat)
Thread:
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

In response to

  • datestyle at 2000-09-09 08:19:09 from pgsql-bugs

pgsql-bugs by date

Next:From: Tom LaneDate: 2000-09-11 16:10:32
Subject: Re: nested implicit selects (views) go wrong
Previous:From: Lamar OwenDate: 2000-09-11 14:43:11
Subject: Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group