Subject: Re: [GENERAL] Bug in function to_char() !!

Message-Id: <E1Bg0y0-0004mq-00(at)gaul(dot)cornfield(dot)org(dot)uk>
From: simonw(at)cornfield(dot)org(dot)uk
Date: Thu, 01 Jul 2004 13:47:04 +0100

Hi

Try

SELECT to_char('2005-03-27'::date,'YYYY/MM/DD');

I think you date format is wrong

Simon

---- Original Message ----
From: Najib Abi Fadel
Date: Thu 7/1/04 8:18
To: generalpost
Subject: [GENERAL] Bug in function to_char() !!

Hi, i am using PostgreSQL 7.3.2=20

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

For other dates the function works well !!
--=20
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Mailscanner thanks transtec Computers for their support.

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Mailscanner thanks transtec Computers for their support.