Re: Bug in function to_char() !!
От | Najib Abi Fadel |
---|---|
Тема | Re: Bug in function to_char() !! |
Дата | |
Msg-id | 006501c46346$681e6720$f664a8c0@najib обсуждение исходный текст |
Ответ на | Bug in function to_char() !! ("Najib Abi Fadel" <nabifadel@usj.edu.lb>) |
Ответы |
Re: Bug in function to_char() !!
|
Список | pgsql-general |
> 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
В списке pgsql-general по дате отправления: