From: | Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | DateStyle bug |
Date: | 2002-02-21 19:44:27 |
Message-ID: | m3k7t6liw4.fsf@dep4.fciencias.unam.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Guys,
While porting an aplication from 7.0 to 7.2 I found a bug with the use
of DateStyle variable:
masm(at)dep4$ psql test
test=# set DateStyle to 'European' ;
SET VARIABLE
test=# select now()::date;
now
------------
2002-02-21
(1 row)
test=# \c test
You are now connected to database test
test=# set DateStyle to 'Postgres' ;
SET VARIABLE
test=# set DateStyle to 'European' ;
SET VARIABLE
test=# select now()::date;
now
------------
21-02-2002
(1 row)
test=# select version();
version
-----------------------------------------------------------
PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
Regards,
Manuel Sugawara.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-02-21 20:05:59 | Re: [HACKERS] fmgr_info: function 20071: cache lookup failed |
Previous Message | Tom Lane | 2002-02-21 19:10:05 | Re: \connect case-folding change maybe not such a good idea |