Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 351D52E012F for ; Thu, 6 Mar 2008 18:53:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 67951-07 for ; Thu, 6 Mar 2008 18:53:18 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.187]) by postgresql.org (Postfix) with ESMTP id 07C522E00F9 for ; Thu, 6 Mar 2008 18:53:23 -0400 (AST) Received: by rv-out-0910.google.com with SMTP id g13so49507rvb.43 for ; Thu, 06 Mar 2008 14:53:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=UnBq20dEuxuU8zAPngNUdm7NPCp3M5QEOVbKlNw+3Uc=; b=m9fpHhwpS76etcnIDRJHxQ/zf8B28bK12sZqa6R+w//7QfTZOYm06DqLT2aH/S3SLxlple6S/X+AXOpUAcdLBP0fIPRFC+JihR5Avn+nFj5Il1jz+ayfwDEPllAX1+Q+uaPGXLinAL5aKwTo/CxLVdlEh5J/U2TX1xeGz1jH2hE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=nzstmWzJW977LErWsTmgg4eOof7c9ZJB6N3GfGlRbGNRTFv552tSY3rckdgvg5MrAipKb3el3aNl1P7zNsE2y1QF2mvYNuAd33tcrGOclKlRSmc/ANAlRhEVBqYV/uxYX8I+pVqVwaXHWO+H/hzyRe+xucc3veNyXYuv+jsUrD0= Received: by 10.141.33.21 with SMTP id l21mr255544rvj.105.1204844002715; Thu, 06 Mar 2008 14:53:22 -0800 (PST) Received: by 10.141.75.16 with HTTP; Thu, 6 Mar 2008 14:53:22 -0800 (PST) Message-ID: <2d6659d70803061453n4d685bbeo7ab74353853dbe08@mail.gmail.com> Date: Fri, 7 Mar 2008 09:23:22 +1030 From: Shilpa To: "Tom Lane" Subject: Re: Time Zone in Postgres Cc: pgsql-admin@postgresql.org In-Reply-To: <19281.1204827832@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6352_12305124.1204844002716" References: <2d6659d70803051856x652174a5ic8655d070a95db59@mail.gmail.com> <2d6659d70803052151q5861981aw3a1a2e39e3970704@mail.gmail.com> <19281.1204827832@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200803/74 X-Sequence-Number: 28557 ------=_Part_6352_12305124.1204844002716 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Tom, We have different databases with different versions. I checked the database with *version 8.2.4* by running the below query echo select timestamp with time zone \'epoch\' + 1206970200 \* INTERVAL \'1 second\'\; | psql template1 ?column? --------------------------- 2008-03-31 23:00:00+09:30 (1 row) This shows the wrong date. The actual result should be *2008-04-01 00:00:00+10:30 * Thanks and Regards, On Fri, Mar 7, 2008 at 4:53 AM, Tom Lane wrote: > Vishal Arora writes: > > Hi, I've been working on a timezone issue. I am in Adelaide Australia > > and the daylight savings time this year has been changed. I am trying > > to figure out the file which is required to be changed. > > The easiest and best solution would be to update to a newer PG release > than 8.0.9 --- installing 8.0.15 over it would be painless and would fix > a number of problems besides this one, including some rather nasty > data-loss risks. > > If you really can't be bothered with that, you can probably use your > operating system's copy of the timezone data files (try under > /usr/share/zoneinfo for starters). > > regards, tom lane > ------=_Part_6352_12305124.1204844002716 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Tom,

We have different databases with different versions.

I checked the database with version 8.2.4 by running the below query

echo select timestamp with time zone \'epoch\' + 1206970200 \* INTERVAL \'1 second\'\; | psql template1
         ?column?
---------------------------
 2008-03-31 23:00:00+09:30
(1 row)

This shows the wrong date. The actual result should be  2008-04-01 00:00:00+10:30

Thanks and Regards,



On Fri, Mar 7, 2008 at 4:53 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Vishal Arora <aroravishal22@hotmail.com> writes:
> Hi, I've been working on a timezone issue. I am in Adelaide Australia
> and the daylight savings time this year has been changed. I am trying
> to figure out the file which is required to be changed.

The easiest and best solution would be to update to a newer PG release
than 8.0.9 --- installing 8.0.15 over it would be painless and would fix
a number of problems besides this one, including some rather nasty
data-loss risks.

If you really can't be bothered with that, you can probably use your
operating system's copy of the timezone data files (try under
/usr/share/zoneinfo for starters).

                       regards, tom lane

------=_Part_6352_12305124.1204844002716--