Re: [SQL] subtract a day from the NOW function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kevin Hunter <hunteke(at)earlham(dot)edu>
Cc: Michael Glaesemann <grzm(at)seespotcode(dot)net>, Steve Crawford <scrawford(at)pinpointresearch(dot)com>, Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Lance Campbell <lance(at)uiuc(dot)edu>, PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: [SQL] subtract a day from the NOW function
Date: 2007-06-08 04:12:10
Message-ID: 15013.1181275930@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Kevin Hunter <hunteke(at)earlham(dot)edu> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick TJ McPhee 2007-06-08 04:13:54 Re: index vs. seq scan choice?
Previous Message Kevin Hunter 2007-06-08 03:31:14 Re: [SQL] subtract a day from the NOW function

Browse pgsql-sql by date

  From Date Subject
Next Message John Meyer 2007-06-08 04:45:00 Re: [SQL] subtract a day from the NOW function
Previous Message Kevin Hunter 2007-06-08 03:31:14 Re: [SQL] subtract a day from the NOW function