> You didn't answer the question though: what timezone are you using?
Asia/Beirut
> If "SHOW timezone" produces something specific, that is the answer.
> If it says "unknown" then what you will need to do is work out
Show timezone says "unknown"
> which of the files under /usr/share/zoneinfo is an exact match
> for /etc/localtime.
I have a file : /usr/share/zoneinfo/Asia/Beirut
> Also, was your Postgres built with --enable-integer-datetimes by
> any chance? (Look at the output of pg_config --configure if you
> are not sure.)
pg_config --configure
'CC=/usr/bin/gcc'
PS : I want just to remember that the to_char(date,'DD/MM/YYYY') works fine
for all dates except the date '2005-03-27'
SELECT to_char('2005-03-27'::date,'DD/MM/YYYY');
to_char
------------
26/03/2005
SELECT to_char('2005-03-20'::date,'DD/MM/YYYY');
to_char
------------
20/03/2005
SELECT to_char('2004-06-07'::date,'DD/MM/YYYY');
to_char
------------
07/06/2004