| 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)
| 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 |