Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 0D4ED9FB3A2 for ; Mon, 19 Feb 2007 16:06:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 54754-08 for ; Mon, 19 Feb 2007 16:06:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by postgresql.org (Postfix) with ESMTP id B305A9FB365 for ; Mon, 19 Feb 2007 16:06:33 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id F0784118A35; Mon, 19 Feb 2007 15:06:32 -0500 (EST) Date: Mon, 19 Feb 2007 15:06:32 -0500 From: Ray Stell To: pgsql-admin@postgresql.org Subject: dst 2007? Message-ID: <20070219200632.GA25911@cns.vt.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200702/273 X-Sequence-Number: 24738 Is your database ready for the Daylight Savings Times change of 2007? http://people.planetpostgresql.org/greg/index.php?/archives/96-Is-your-database-ready-for-the-Daylight-Savings-Times-change-of-2007.html in the pg share dir: $ /usr/sbin/zdump -v EST5EDT | grep 2007 EST5EDT Sun Mar 11 06:59:59 2007 UTC = Sun Mar 11 01:59:59 2007 EST isdst=0 gmtoff=-18000 EST5EDT Sun Mar 11 07:00:00 2007 UTC = Sun Mar 11 03:00:00 2007 EDT isdst=1 gmtoff=-14400 EST5EDT Sun Nov 4 05:59:59 2007 UTC = Sun Nov 4 01:59:59 2007 EDT isdst=1 gmtoff=-14400 EST5EDT Sun Nov 4 06:00:00 2007 UTC = Sun Nov 4 01:00:00 2007 EST isdst=0 gmtoff=-18000 Nice to see it in b&w on the system of interest. Thx, Greg.