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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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