Re: BUG #3563: DATESTYLE feature suggestion

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Russell Smith <mr-russ(at)pws(dot)com(dot)au>
Cc: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Randolf Richardson <randolf+postgresql(dot)org(at)inter-corporate(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3563: DATESTYLE feature suggestion
Date: 2007-08-22 13:43:21
Message-ID: 20070822134321.GC32099@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Russell Smith wrote:

> The issue is output, not input.
>
> SET datestyle='dmy';
> SELECT '03-03-2004'::date
>
> Will return '2007-03-03', not 03-03-2004 as is the set datestyle.

You are aware that DateStyle controls both input and output,
_separately_, yes?

--
Alvaro Herrera http://www.advogato.org/person/alvherre
A male gynecologist is like an auto mechanic who never owned a car.
(Carrie Snow)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2007-08-22 15:06:57 Re: BUG #3563: DATESTYLE feature suggestion
Previous Message Tom Lane 2007-08-22 13:42:11 Re: BUG #3567: invalid page header in block XXXXof relation