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

From Russell Smith
Subject Re: BUG #3563: DATESTYLE feature suggestion
Date
Msg-id 46CD3C6C.5010604@pws.com.au
Whole thread Raw
In response to Re: BUG #3563: DATESTYLE feature suggestion  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3571: call to decrypt causes segfault
Next
From: Zdenek Kotala
Date:
Subject: Re: BUG #3567: invalid page header in block XXXXof relation