Re: Bug in function to_char() !!

[cpn@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@zorbla.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@zorbla.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@postgresql.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/