Subject: Re: [SQL] Interval subtracting
From: Hannu Krosing <hannu@skype.net>
To: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: pgsql-hackers@postgresql.org
In-Reply-To: <1141315989.18820.56.camel@state.g2switchworks.com>
References: <200603012027.k21KRk423759@candle.pha.pa.us>
	<1141245396.18820.16.camel@state.g2switchworks.com>
	<1141281952.3737.17.camel@localhost.localdomain>
	<1141315989.18820.56.camel@state.g2switchworks.com>
Content-Type: text/plain; charset=utf-8
Date: Thu, 02 Mar 2006 19:50:11 +0200
Message-Id: <1141321812.3786.4.camel@localhost.localdomain>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit

Ühel kenal päeval, N, 2006-03-02 kell 10:13, kirjutas Scott Marlowe:
> On Thu, 2006-03-02 at 00:45, Hannu Krosing wrote:
> > Ühel kenal päeval, K, 2006-03-01 kell 14:36, kirjutas Scott Marlowe:
..
> > > We don't say 42 degrees, -12 minutes when measuring arc, do we?  Then
> > > again, maybe some folks do.  It just seems wrong to me.
> > 
> > But we do say both "quarter past three" (3 hours 15 min) and "quarter to
> > four" (4 hours -15 min) when talking about time.
> 
> But the military says 1515 or 1545 or 0315 or 0345, because if they get
> the time wrong they shell the wrong place and kill their own soldiers.

do they also speak so of intervals ? 

hannu=# select now(), now() - '-1 hour ago'::interval;
              now              |           ?column?
-------------------------------+-------------------------------
 2006-03-02 19:47:38.042408+02 | 2006-03-02 18:47:38.042408+02
(1 row)

You see what I mean - perfectly precise and unconfusable :)

> I.e. getting it right is important to them.  So they use exact
> language.  I prefer the more exact way.

And in the current global era they must also speak in GMT all the time,
to avoid any confusion :P

--------------
Hannu