X-Original-To: pgsql-sql@postgresql.org Received: from ara.zf.jcu.cz (ara.zf.jcu.cz [160.217.161.4]) by postgresql.org (Postfix) with ESMTP id A34AC475FBA for ; Tue, 18 Mar 2003 02:45:06 -0500 (EST) Received: from ara.zf.jcu.cz (localhost [127.0.0.1]) by ara.zf.jcu.cz (8.12.1/8.12.1/Debian -5) with ESMTP id h2I7iupp018148; Tue, 18 Mar 2003 08:44:56 +0100 Received: (from zakkr@localhost) by ara.zf.jcu.cz (8.12.1/8.12.1/Debian -5) id h2I7imlm018142; Tue, 18 Mar 2003 08:44:48 +0100 Date: Tue, 18 Mar 2003 08:44:47 +0100 From: Karel Zak To: Josh Berkus Cc: Rajesh Kumar Mallah , Christoph Haller , pgsql-sql@postgresql.org, jasiek@klaster.net Subject: Re: Formatting intervals.. Message-ID: <20030318074447.GG5283@zf.jcu.cz> References: <3E75DB1C.CA0A3F06@rodos.fzk.de> <200303172024.03256.mallah@trade-india.com> <200303171000.17266.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200303171000.17266.josh@agliodbs.com> User-Agent: Mutt/1.3.28i X-Archive-Number: 200303/425 X-Sequence-Number: 12464 On Mon, Mar 17, 2003 at 10:00:17AM -0800, Josh Berkus wrote: > Guys, > > BTW, a "to_char" function for INTERVAL is on the TODO list. We just haven't > had a volunteer to complete it. test=# select to_char('3month 15d 4h 10m'::interval, 'DD-Mon HH24:MI:SS'); to_char ----------------- 15-Mar 04:10:00 It's evidently described in docs :-). The implementation is not absolutely perfec (see list archive), but for basic things it's usable. Karel -- Karel Zak http://home.zf.jcu.cz/~zakkr/