On Thu, 2004-07-01 at 14:48, Stefan Kaltenbrunner wrote:
> Najib Abi Fadel wrote:
> > I exactly typed what i sent.
> > Anyone with Postgresql 7.3.2 PLEASE try it and tell me what happens.
> >
> > SELECT to_char('2005-03-27'::date,'DD/MM/YYYY');
>
>
> template1=# select version();
> version
> ------------------------------------------------------------------------
> PostgreSQL 7.3.2 on i386-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
> (1 row)
>
> template1=# SELECT to_char('2005-03-27'::date,'DD/MM/YYYY');
> to_char
> ------------
> 27/03/2005
> (1 row)
I had the same problem in php due to DST, but that I guess depends on
the underlaying (buggy?) libc.
using 2005-03-27 12:00 instead of just 2005-03-27 solved the problem for
me.
regards,
Robin