Subject: Re: [GENERAL] Bug in function to_char() !!
Message-Id: <[EMAIL PROTECTED]>
From: [EMAIL PROTECTED]
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.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
