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/