...

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

Message-Id: <E1Bg0y0-0004mq-00@gaul.cornfield.org.uk>
From: simonw@cornfield.org.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.