Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 3E5E62E0048 for ; Thu, 24 Apr 2008 05:58:20 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48334-06 for ; Thu, 24 Apr 2008 05:58:14 -0300 (ADT) X-Greylist: delayed 00:10:19.737128 by SQLgrey-1.7.5 Received: from FP-IAD1-1.synapse.com (h-69-3-86-138.mclnva23.covad.net [69.3.86.138]) by developer.postgresql.org (Postfix) with ESMTP id 114962E0044 for ; Thu, 24 Apr 2008 05:58:13 -0300 (ADT) X-TM-IMSS-Message-ID: <75a056aa00001661@globallogic.com> Received: from imss.synapse.com ([192.168.0.3]) by globallogic.com ([172.17.32.11]) with ESMTP (TREND IMSS SMTP Service 7.0) id 75a056aa00001661 for ; Thu, 24 Apr 2008 04:47:49 -0500 X-TM-IMSS-Message-ID: <08f1caa500000e83@globallogic.com> Received: from ex2-del1.synapse.com ([172.16.2.50]) by globallogic.com ([192.168.0.3]) with ESMTP (TREND IMSS SMTP Service 7.0) id 08f1caa500000e83 for ; Thu, 24 Apr 2008 14:17:42 +0530 Received: from 172.16.45.102 ([172.16.45.102]) by ex2-del1.synapse.com ([172.16.2.50]) with Microsoft Exchange Server HTTP-DAV ; Thu, 24 Apr 2008 08:47:55 +0000 Received: from bob by mapi.globallogic.com; 24 Apr 2008 14:15:51 +0530 Subject: Problem with SGT (Singapore) timezone From: Abhishek Mishra To: pgsql-admin@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1209026751.6110.193.camel@bob> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Thu, 24 Apr 2008 14:15:51 +0530 X-TM-AS-Product-Ver: IMSS-7.0.0.6126-5.5.0.1026-15868.006 X-TM-AS-Result: No--6.835-5.0-31-1 X-imss-scan-details: No--6.835-5.0-31-1 X-TM-AS-User-Approved-Sender: No X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.1 tagged_above=0 required=5 tests=RDNS_DYNAMIC=0.1 X-Spam-Level: X-Archive-Number: 200804/243 X-Sequence-Number: 29007 Hi Folks, I am using postgresql version 8.1.2. On using the SGT time zone on my machine, I get following error: ERROR: invalid input syntax for type timestamp: "Tue Jan 15 04:09:43.729011 2008 SGT" Could anyone please tell me any known issue in using SGT timezone. It works well if I use GMT timezone. Please tell me if anything could be done to support SGT. Kind Regards, -Abhishek Mishra