Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 1ACCD9FB45A for ; Tue, 19 Jun 2007 13:20:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 48368-02 for ; Tue, 19 Jun 2007 13:20:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 5732E9FB5F8 for ; Tue, 19 Jun 2007 13:20:14 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l5JGKAth000505; Tue, 19 Jun 2007 12:20:10 -0400 (EDT) To: "soni de" cc: pgsql-performance@postgresql.org Subject: Re: Regarding Timezone In-reply-to: <9f2e40a90706190042x6016b395od1eca739d5205ebd@mail.gmail.com> References: <9f2e40a90706190042x6016b395od1eca739d5205ebd@mail.gmail.com> Comments: In-reply-to "soni de" message dated "Tue, 19 Jun 2007 13:12:58 +0530" Date: Tue, 19 Jun 2007 12:20:10 -0400 Message-ID: <504.1182270010@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/362 X-Sequence-Number: 25395 "soni de" writes: > But we want to set this timezone parameter to IST. Which "IST" are you interested in? Irish, Israel, or Indian Standard Time? Postgres prefers to use the zic timezone names, which are less ambiguous. Try this to see likely options: regression=# select * from pg_timezone_names where abbrev = 'IST'; name | abbrev | utc_offset | is_dst ---------------+--------+------------+-------- Asia/Calcutta | IST | 05:30:00 | f Asia/Colombo | IST | 05:30:00 | f Europe/Dublin | IST | 01:00:00 | t Eire | IST | 01:00:00 | t (4 rows) If you're after Indian Standard Time, set timezone to 'Asia/Calcutta'. You'll probably also want to set timezone_abbreviations to 'India' so that "IST" is interpreted the way you want in timestamp datatype input. See http://www.postgresql.org/docs/8.2/static/datetime-config-files.html regards, tom lane