Re: Bug in function to_char() !!

On Thu, Jul 01, 2004 at 09:47:38AM +0200, Najib Abi Fadel wrote:
> 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 !!!

7.5devel:

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


The date looks like some date when is daylight saving time change,
maybe it's something already knows and fixed.

Can you check results of:

# SELECT '2005-03-27'::timestamp;
timestamp
---------------------
2005-03-27 00:00:00

# SHOW TIMEZONE;
TimeZone
---------------
Europe/Prague

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/