Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B2B199FB4C3 for ; Fri, 8 Jun 2007 01:12:31 -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 61188-03 for ; Fri, 8 Jun 2007 01:12:23 -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 C69DE9FB478 for ; Fri, 8 Jun 2007 01:12:24 -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 l584CArD015014; Fri, 8 Jun 2007 00:12:10 -0400 (EDT) To: Kevin Hunter cc: Michael Glaesemann , Steve Crawford , Scott Marlowe , Lance Campbell , PostgreSQL General List Subject: Re: [SQL] subtract a day from the NOW function In-reply-to: <4668CD82.1020207@earlham.edu> References: <9938A77A-6E63-413D-8AC9-7CB741D075E6@seespotcode.net> <46684A70.4080903@g2switchworks.com> <4668555E.20003@pinpointresearch.com> <46687395.80707@pinpointresearch.com> <4668CD82.1020207@earlham.edu> Comments: In-reply-to Kevin Hunter message dated "Thu, 07 Jun 2007 23:31:14 -0400" Date: Fri, 08 Jun 2007 00:12:10 -0400 Message-ID: <15013.1181275930@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/565 X-Sequence-Number: 115388 Kevin Hunter writes: > 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. Or at least get rid of daylight savings, which has to be one of the worst ideas of the last 200 years ... regards, tom lane