Re: [GENERAL] Bug in function to_char() !!

2004-07-06 Thread Tom Lane
"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

Re: [GENERAL] Bug in function to_char() !!

2004-07-06 Thread Najib Abi Fadel
> 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

Re: [GENERAL] Bug in function to_char() !!

2004-07-01 Thread Maciej BliziƄski
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: