"Najib Abi Fadel" <nabifadel(at)usj(dot)edu(dot)lb> writes:
> SELECT to_char('2005-03-27'::date,'DD/MM/YYYY');
> to_char
> ------------
> 26/03/2005
> (1 row)
What timezone setting are you using, and what kind of system is this on?
I suppose that day is a daylight-savings transition day for you, but no
one else is likely to reproduce the problem in a different zone ...
regards, tom lane