DateStyle bug - Mailing list pgsql-hackers

From Manuel Sugawara
Subject DateStyle bug
Date
Msg-id m3k7t6liw4.fsf@dep4.fciencias.unam.mx
Whole thread Raw
List pgsql-hackers
Guys, 

While porting an aplication from 7.0 to 7.2 I found a bug with the use
of DateStyle variable:

masm@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.


pgsql-hackers by date:

Previous
From: Patrice Hédé
Date:
Subject: Re: UTF-8 data migration problem in Postgresql 7.2
Next
From: Jean-Michel POURE
Date:
Subject: [pgadmin-hackers] Feature request: md5sum footprint of schema objects