"Najib Abi Fadel" <[EMAIL PROTECTED]> writes:
>> You didn't answer the question though: what timezone are you using?
> Asia/Beirut
Okay, with that I can reproduce it. That zone is one of the ones where
the DST transitions occur just at midnight. So there really isn't any
"midnight local time" o
> 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
Najib Abi Fadel wrote:
Hi, i am using PostgreSQL 7.3.2
there's a bug for the date '2005-03-27' !!!
For other dates the function works well !!
I have 7.4.2 and it works well:
[EMAIL PROTECTED]:~$ psql template1
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.
Type: