X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D62AA475C15 for ; Tue, 25 Mar 2003 23:44:23 -0500 (EST) Received: from wolff.to (wolff.to [66.93.249.74]) by postgresql.org (Postfix) with SMTP id 16A2C474E44 for ; Tue, 25 Mar 2003 23:44:23 -0500 (EST) Received: (qmail 18556 invoked by uid 500); 26 Mar 2003 04:43:56 -0000 Date: Tue, 25 Mar 2003 22:43:56 -0600 From: Bruno Wolff III To: Tomasz Myrta Cc: Josh Berkus , pgsql-sql@postgresql.org Subject: Re: Does anyone use TO_CHAR(INTERVAL)? Message-ID: <20030326044356.GA18525@wolff.to> Mail-Followup-To: Tomasz Myrta , Josh Berkus , pgsql-sql@postgresql.org References: <200303250931.27351.josh@agliodbs.com> <3E80AD07.5000005@klaster.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3E80AD07.5000005@klaster.net> User-Agent: Mutt/1.3.25i X-Spam-Status: No, hits=-38.0 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/571 X-Sequence-Number: 12609 On Tue, Mar 25, 2003 at 20:24:55 +0100, Tomasz Myrta wrote: > Uz.ytkownik Josh Berkus napisa?: > > It looks it could be useful to display how much time is left for > scheduling cases, but as I wrote few threads ago - displaying intervals > longer than one month is useless without specific date. That isn't true. Intervals have two parts. One is time difference in fixed time and the other is a difference in months. You could display both parts when they are both nonzero. I haven't found the documenation too specific on which part gets added first (and this does make a difference in some cases).