Re: Bug in function to_char() !!
От | Najib Abi Fadel |
---|---|
Тема | Re: Bug in function to_char() !! |
Дата | |
Msg-id | 006201c4628a$29e997c0$f664a8c0@najib обсуждение исходный текст |
Ответ на | Bug in function to_char() !! ("Najib Abi Fadel" <nabifadel@usj.edu.lb>) |
Ответы |
Re: Bug in function to_char() !!
|
Список | pgsql-general |
[root@STIsrv root]# uname -a Linux STIsrv 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux [root@STIsrv root]# date Mon Jul 5 13:22:55 EEST 2004 I tried to change the timezone (using timeconfig) i have always: dragon_devel=# SELECT to_char('2005-03-27'::date,'DD/MM/YY'); to_char ---------- 26/03/05 (1 row) NOTE THAT IF I USE TIMESTAMP IT WORKS:: dragon_devel=# SELECT to_char('2005-03-27'::timestamp,'DD/MM/YY'); to_char ---------- 27/03/05 (1 row) i am using Red HAt 8.0 I have tried the same command on 2 different servers (same postgres version) dragon_devel=# SELECT version(); version ---------------------------------------------------------------------------- ----------------------------- PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) (1 row) ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Najib Abi Fadel" <nabifadel@usj.edu.lb> Cc: "generalpost" <pgsql-general@postgresql.org> Sent: Thursday, July 01, 2004 4:52 PM Subject: Re: [GENERAL] Bug in function to_char() !! > "Najib Abi Fadel" <nabifadel@usj.edu.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 > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
В списке pgsql-general по дате отправления: