Re: [SQL] Interval subtracting
От | Hannu Krosing |
---|---|
Тема | Re: [SQL] Interval subtracting |
Дата | |
Msg-id | 1141321812.3786.4.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: [SQL] Interval subtracting (Scott Marlowe <smarlowe@g2switchworks.com>) |
Список | pgsql-hackers |
Ü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
В списке pgsql-hackers по дате отправления: