Re: [SQL] subtract a day from the NOW function - Mailing list pgsql-general

From Kevin Hunter
Subject Re: [SQL] subtract a day from the NOW function
Date
Msg-id 4668CD82.1020207@earlham.edu
Whole thread Raw
Responses Re: [SQL] subtract a day from the NOW function
List pgsql-general
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

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: list all columns in db
Next
From: Tom Lane
Date:
Subject: Re: [SQL] subtract a day from the NOW function