Re: Bug in function to_char() !!

[cpn(at)s00 work]$ rpm -q postgresql
postgresql-7.3.4-11

Fedora Core 1

KakaoStats=# SELECT
to_char('2005-03-27'::date,'DD/MM/YYYY');
to_char
------------
27/03/2005
(1 row)

--- Dirk_Försterling <r(at)zorbla(dot)de> escreveu: > Najib
Abi Fadel wrote:
> > Hi, i am using PostgreSQL 7.3.2
> >
> > there's a bug for the date '2005-03-27'
> !!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> I think you should replace or clean your keyboard.
> At least one key
> seems to be sticky.
>
> > SELECT to_char('2005-03-27'::date,'DD/MM/YYYY');
> > to_char
> > ------------
> > 26/03/2005
> > (1 row)
>
> No problem with 7.2.1 and 7.4.1. (don't have a 7.3.2
> around).
> Both work correctly:
>
> dirk=> SELECT
> to_char('2005-03-27'::date,'DD/MM/YYYY');
> to_char
> ------------
> 27/03/2005
> (1 row)
>
> --
> D i r k F "o r s t e r l i n g
> r(at)zorbla(dot)de http://r.zorbla.de/
> -------------
> "A radioactive cat has eighteen
> half-lives."
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list
> cleanly
>

______________________________________________________________________

Yahoo! Mail - agora com 100MB de espaço, anti-spam e antivírus grátis!
http://br.info.mail.yahoo.com/