From: | Hannu Krosing <hannu(at)skype(dot)net> |
---|---|
To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [SQL] Interval subtracting |
Date: | 2006-03-02 17:50:11 |
Message-ID: | 1141321812.3786.4.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches pgsql-sql |
Ü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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-03-02 17:56:27 | Re: Automatic free space map filling |
Previous Message | Jonah H. Harris | 2006-03-02 17:21:50 | INS/UPD/DEL Returning Patch |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Dilger | 2006-03-02 18:06:26 | Re: [SQL] Interval subtracting |
Previous Message | Scott Marlowe | 2006-03-02 16:13:09 | Re: [SQL] Interval subtracting |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Dilger | 2006-03-02 18:06:26 | Re: [SQL] Interval subtracting |
Previous Message | Michael Fuhr | 2006-03-02 17:04:14 | Re: Question about Sql SELECT and optimizer |