pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Kevin Hunter <hunteke@earlham.edu>
To: Michael Glaesemann <grzm@seespotcode.net>
Cc: Steve Crawford <scrawford@pinpointresearch.com>
Cc: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Lance Campbell <lance@uiuc.edu>
Cc: PostgreSQL General List <pgsql-general@postgresql.org>
Subject: Re: [SQL] subtract a day from the NOW function
Date: Thu, 07 Jun 2007 23:31:14 -0400
Message-ID: <4668CD82.1020207@earlham.edu> (raw)
In-Reply-To: <C6AE494E-146A-443E-9E54-AE95F2943B1F@seespotcode.net>
References: <A3AC4FA47DC0B1458C3E5396E685E63302395E24@SAB-DC1.sab.uiuc.edu>
	<A3AC4FA47DC0B1458C3E5396E685E63302395E25@SAB-DC1.sab.uiuc.edu>
	<9938A77A-6E63-413D-8AC9-7CB741D075E6@seespotcode.net>
	<A3AC4FA47DC0B1458C3E5396E685E63302395E27@SAB-DC1.sab.uiuc.edu>
	<46684A70.4080903@g2switchworks.com>
	<4668555E.20003@pinpointresearch.com>
	<D3436F83-5008-4CA3-B056-E792654B4F73@seespotcode.net>
	<46687395.80707@pinpointresearch.com>
	<C6AE494E-146A-443E-9E54-AE95F2943B1F@seespotcode.net>

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



view thread (19+ messages)  latest in thread

Message-ID: <4668CD82.1020207@earlham.edu>
Permalink:  ../4668CD82.1020207@earlham.edu/
Also on:    postgresql.org/message-id/4668CD82.1020207@earlham.edu

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: hunteke@earlham.edu, grzm@seespotcode.net, scrawford@pinpointresearch.com, smarlowe@g2switchworks.com, lance@uiuc.edu, pgsql-general@postgresql.org
  Subject: Re: [SQL] subtract a day from the NOW function
  In-Reply-To: <4668CD82.1020207@earlham.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox