Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id E43919FB64B
	for <pgsql-general-postgresql.org@postgresql.org>;
	Fri,  8 Jun 2007 00:31:24 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 26043-03 for
	<pgsql-general-postgresql.org@postgresql.org>;
	Fri,  8 Jun 2007 00:31:20 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from sipala.earlham.edu (sipala.earlham.edu [159.28.1.75])
	by postgresql.org (Postfix) with ESMTP id 4C87B9FB584
	for <pgsql-general@postgresql.org>;
	Fri,  8 Jun 2007 00:31:21 -0300 (ADT)
Received: from [192.168.2.101] (74-132-13-58.dhcp.insightbb.com
 [74.132.13.58])
	(authenticated bits=0)
	by sipala.earlham.edu (8.13.6/8.13.6) with ESMTP id l583VBVu012658
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Thu, 7 Jun 2007 23:31:12 -0400 (EDT)
X-Authentication-Warning: sipala.earlham.edu: Host
	74-132-13-58.dhcp.insightbb.com [74.132.13.58] claimed to be
	[192.168.2.101]
Message-ID: <4668CD82.1020207@earlham.edu>
Date: Thu, 07 Jun 2007 23:31:14 -0400
From: Kevin Hunter <hunteke@earlham.edu>
User-Agent: Thunderbird 1.5.0.7 (X11/20060909)
MIME-Version: 1.0
To: Michael Glaesemann <grzm@seespotcode.net>
CC: Steve Crawford <scrawford@pinpointresearch.com>,
	Scott Marlowe <smarlowe@g2switchworks.com>,
	Lance Campbell <lance@uiuc.edu>,
	PostgreSQL General List <pgsql-general@postgresql.org>
Subject: Re: [SQL] subtract a day from the NOW function
References: <A3AC4FA47DC0B1458C3E5396E685E63302395E24@SAB-DC1.sab.uiuc.edu>
	<A3AC4FA47DC0B1458C3E5396E685E63302395E25@SAB-DC1.sab.uiuc.edu>
	<9938A77A-6E63-413D-8AC9-7CB741D075E6@seespotcode.net>
	<A3AC4FA47DC0B1458C3E5396E685E63302395E27@SAB-DC1.sab.uiuc.edu>
	<46684A70.4080903@g2switchworks.com>
	<4668555E.20003@pinpointresearch.com>
	<D3436F83-5008-4CA3-B056-E792654B4F73@seespotcode.net>
	<46687395.80707@pinpointresearch.com>
	<C6AE494E-146A-443E-9E54-AE95F2943B1F@seespotcode.net>
In-Reply-To: <C6AE494E-146A-443E-9E54-AE95F2943B1F@seespotcode.net>
X-Enigmail-Version: 0.94.1.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/564
X-Sequence-Number: 115387

At 5:57p -0400 on 07 Jun 2007, Michael Glaesemann wrote:
> It is a bit tricky. Datetime math is inherently so.

So one wonders why the whole world doesn't migrate to a single timezone.
 There would be no more confusion between EST, CEST, GMT, +1100, etc.
The trade off, of course, would be that now you'd have to know the
"daylight" hours of a particular part of the world or business with whom
you wanted to interact, but the math sure would be easier all-round.

Kevin