Bug in function to_char() !!

From: "Najib Abi Fadel" <nabifadel(at)usj(dot)edu(dot)lb>
To: "generalpost" <pgsql-general(at)postgresql(dot)org>
Subject: Bug in function to_char() !!
Date: 2004-07-01 07:47:38
Message-ID: 001c01c45f3f$b1931000$9d64a8c0@najib
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 !!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karel Zak 2004-07-01 07:49:15 Re: Bug in function to_char() !!
Previous Message Christopher Cashell 2004-07-01 07:45:08 Re: Problems restarting after database crashed (signal