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@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/