Home > mailing lists

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

From	Najib Abi Fadel
Subject	Bug in function to_char() !!
Date	July 1, 2004 07:10:34
Msg-id	001c01c45f3f$b1931000$9d64a8c0@najib Whole thread Raw
Responses	Re: Bug in function to_char() !! Re: Bug in function to_char() !! Re: Bug in function to_char() !! Re: Bug in function to_char() !!
List	pgsql-general

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 !!

From: Tom Lane
Date: 01 July 2004, 06:38:14
Subject: Re: case for lock_timeout

From: Christopher Cashell
Date: 01 July 2004, 07:48:17
Subject: Re: Problems restarting after database crashed (signal