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

From: Kevin Hunter <hunteke(at)earlham(dot)edu>
To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: 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 03:31:14
Message-ID: 4668CD82.1020207@earlham.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-06-08 04:12:10 Re: [SQL] subtract a day from the NOW function
Previous Message Michael Fuhr 2007-06-08 02:24:47 Re: list all columns in db

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2007-06-08 04:12:10 Re: [SQL] subtract a day from the NOW function
Previous Message osmar della paschoa jr 2007-06-08 00:59:04 Re: [ADMIN] the right time to vacuum database?