Re: BUG #3563: DATESTYLE feature suggestion

From: Russell Smith <mr-russ(at)pws(dot)com(dot)au>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
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-23 07:51:08
Message-ID: 46CD3C6C.5010604@pws.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alvaro Herrera wrote:
> 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?
>

No, I've RTFM'd to fix that.

Thanks

Russell

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Marko Kreen 2007-08-23 08:54:58 Re: BUG #3571: call to decrypt causes segfault
Previous Message Tom Lane 2007-08-22 23:42:52 Re: BUG #3571: call to decrypt causes segfault