X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 4F8329DC814 for ; Thu, 2 Mar 2006 03:05:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12048-05 for ; Thu, 2 Mar 2006 03:05:15 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by postgresql.org (Postfix) with ESMTP id 183409DCC14 for ; Thu, 2 Mar 2006 03:05:13 -0400 (AST) Received: from [192.168.178.99] (p548B4A21.dip0.t-ipconnect.de [84.139.74.33]) by service-web.de (Postfix) with ESMTP id D009420002D; Thu, 2 Mar 2006 08:05:12 +0100 (CET) Message-ID: <44069927.7000603@wildenhain.de> Date: Thu, 02 Mar 2006 08:05:11 +0100 From: Tino Wildenhain User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051017) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: Hannu Krosing Cc: Scott Marlowe , pgsql-hackers@postgresql.org Subject: Re: [SQL] Interval subtracting References: <200603012027.k21KRk423759@candle.pha.pa.us> <1141245396.18820.16.camel@state.g2switchworks.com> <1141281952.3737.17.camel@localhost.localdomain> In-Reply-To: <1141281952.3737.17.camel@localhost.localdomain> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.127 required=5 tests=[AWL=0.127] X-Spam-Score: 0.127 X-Spam-Level: X-Archive-Number: 200603/101 X-Sequence-Number: 80499 Hannu Krosing schrieb: > Ühel kenal päeval, K, 2006-03-01 kell 14:36, kirjutas Scott Marlowe: > ... > 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 luckily we dont write it ;) Some people say (like ) this: quarter past 3, half past 3, three quartes past 3, 4. Which seems more logical. :-) But "saying" would be a job for to_char, not for internal storage, which should _always_ be canonical. Regards Tino