Re: BUG #3563: DATESTYLE feature suggestion - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #3563: DATESTYLE feature suggestion
Date
Msg-id 20070822134321.GC32099@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #3563: DATESTYLE feature suggestion  (Russell Smith <mr-russ@pws.com.au>)
Responses Re: BUG #3563: DATESTYLE feature suggestion
List 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)

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3567: invalid page header in block XXXXof relation
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: BUG #3563: DATESTYLE feature suggestion