Postgres Pro
Downloads
Home   >   mailing lists

Bug in function to_char() !! - Mailing list pgsql-general

From Najib Abi Fadel
Subject Bug in function to_char() !!
Date
Msg-id 001c01c45f3f$b1931000$9d64a8c0@najib
Whole thread Raw
Responses Re: Bug in function to_char() !!  (Dirk Försterling <r@zorbla.de>)
Re: Bug in function to_char() !!  (Karel Zak <zakkr@zf.jcu.cz>)
Re: Bug in function to_char() !!  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Bug in function to_char() !!  (Maciej Bliziński <maciej.blizinski@magnum2.pl>)
List pgsql-general
Tree view
Hi, i am using PostgreSQL 7.3.2
 
there's a bug for the date '2005-03-27' !!!!!!!!!!!!!!!!!!!!!!!!!!!
 
SELECT to_char('2005-03-27'::date,'DD/MM/YYYY');
  to_char
------------
 26/03/2005
(1 row)
I get the date 26/03/2005 instead of 27/03/2005 !!!
 
For other dates the function works well !!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: case for lock_timeout
Next
From: Christopher Cashell
Date:
Subject: Re: Problems restarting after database crashed (signal