Received: from ara.zf.jcu.cz (ara.zf.jcu.cz [160.217.161.4]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f94EuDn06008 for ; Thu, 4 Oct 2001 10:56:13 -0400 (EDT) (envelope-from zakkr@zf.jcu.cz) Received: from ara.zf.jcu.cz (zakkr@localhost [127.0.0.1]) by localhost (8.12.0.Beta7/8.12.0.Beta7/Debian 8.12.0.Beta7-1) with ESMTP id f94Eu6Th020892; Thu, 4 Oct 2001 16:56:07 +0200 Received: (from zakkr@localhost) by ara.zf.jcu.cz (8.12.0.Beta7/8.12.0.Beta7/Debian 8.12.0.Beta7-1) id f94Eu6br020891; Thu, 4 Oct 2001 16:56:06 +0200 Date: Thu, 4 Oct 2001 16:56:06 +0200 From: Karel Zak To: Josh Berkus Cc: pgsql-sql@postgresql.org Subject: Re: to_date/to timestamp going to BC Message-ID: <20011004165606.D22302@zf.jcu.cz> References: <20011004104149.B9858@zf.jcu.cz> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from josh@agliodbs.com on Thu, Oct 04, 2001 at 07:44:14AM -0700 X-Archive-Number: 200110/51 X-Sequence-Number: 5006 On Thu, Oct 04, 2001 at 07:44:14AM -0700, Josh Berkus wrote: > Karel, > > > .. well, I add it to my TODO for 7.3 (I plan rewrite several things > > in to_* functions). > > How about a to_char function for INTERVAL? Please, oh please? oh, needn't please.. already in right now breeding 7.2 :-) test=# SELECT to_char('5months 3sec 4h 1min'::interval, 'HH:MI:SS Mon'); to_char -------------- 04:01:03 May (1 row) Karel -- Karel Zak http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz