Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 184EA9FB40C for ; Fri, 8 Jun 2007 01:44:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 48999-02 for ; Fri, 8 Jun 2007 01:44:31 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.182]) by postgresql.org (Postfix) with ESMTP id 8AA439FB2FD for ; Fri, 8 Jun 2007 01:44:33 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id k40so1042191wah for ; Thu, 07 Jun 2007 21:44:31 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:subject:references:in-reply-to:x-enigmail-version:content-type:content-transfer-encoding; b=W0Nz3bWs38MneSxOU9cgh24cRXURhQAgiDdT1WrZr5Q8El/PeBv9SR8dPZ3yjCp9C9IGY8O+sKfcEM2pfMIRqCpTluK462VPvRMtXwbkfKzPtjRC8Hi4J5g0lvi6wNhg9tNppq0BmckzJbkkOpraSUDBltMHqiC23dn9h6cGSJo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:subject:references:in-reply-to:x-enigmail-version:content-type:content-transfer-encoding; b=V7jUT7cryyEM10lWPwbjvG+4lPdwS7q1umhK41/1LF0O2rDfKMVieqThqyIpuUsHJIA9aC0cw4EcT4VvDkJmCflzatJh+lcjLqgB/rHvOoBzmqWmFhg9la4Vu+kYxmDeQULGMIWbskFdELCxE8XYeM8OLnWBuiha6C3T090kZ+c= Received: by 10.114.177.1 with SMTP id z1mr2164905wae.1181277871269; Thu, 07 Jun 2007 21:44:31 -0700 (PDT) Received: from ?192.168.0.102? ( [67.164.252.164]) by mx.google.com with ESMTP id j29sm3068744waf.2007.06.07.21.44.29 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 07 Jun 2007 21:44:30 -0700 (PDT) Message-ID: <4668DECC.3090505@gmail.com> Date: Thu, 07 Jun 2007 22:45:00 -0600 From: John Meyer User-Agent: Thunderbird 2.0.0.0 (X11/20070418) MIME-Version: 1.0 To: PostgreSQL General List Subject: Re: [SQL] subtract a day from the NOW function References: <9938A77A-6E63-413D-8AC9-7CB741D075E6@seespotcode.net> <46684A70.4080903@g2switchworks.com> <4668555E.20003@pinpointresearch.com> <46687395.80707@pinpointresearch.com> <4668CD82.1020207@earlham.edu> <15013.1181275930@sss.pgh.pa.us> In-Reply-To: <15013.1181275930@sss.pgh.pa.us> X-Enigmail-Version: 0.95.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/566 X-Sequence-Number: 115389 Tom Lane wrote: > 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 ... > You mean we don't have to worry about defeating Jerry and the Kaiser anymore? Boggles the mind. Seriously, as long as everybody's in agreement, stick to UTC and let the local software developers worry about formatting conversions to and from for display. -- The NCP Revue -- http://www.ncprevue.com/blog