Received: from ara.zf.jcu.cz (ara.zf.jcu.cz [160.217.161.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f268DLx44760 for ; Tue, 6 Mar 2001 03:13:21 -0500 (EST) (envelope-from zakkr@zf.jcu.cz) Received: (from zakkr@localhost) by ara.zf.jcu.cz (8.9.3/8.9.3/Debian 8.9.3-21) id JAA09446; Tue, 6 Mar 2001 09:13:16 +0100 Date: Tue, 6 Mar 2001 09:13:16 +0100 From: Karel Zak To: Josh Berkus Cc: sqllist Subject: Re: No Documentation for to_char(INTERVAL, mask) Message-ID: <20010306091316.B6115@ara.zf.jcu.cz> References: <3AA469E9.DCFFC0AE@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0.1i In-Reply-To: <3AA469E9.DCFFC0AE@agliodbs.com>; from josh@agliodbs.com on Mon, Mar 05, 2001 at 08:39:05PM -0800 X-Archive-Number: 200103/89 X-Sequence-Number: 1737 On Mon, Mar 05, 2001 at 08:39:05PM -0800, Josh Berkus wrote: > Bruce, Tom, et. al., > > I can't find any documentation for what masks to use with the function > TO_CHAR(INTERVAL, mask). Is there a TO_CHAR(INTERVAL)? If so, what > masks are there? If not, how would you suggest I convert an interval The 'interval' version of to_char() isn't implemented -- may be in 7.2 (it's high in my TODO list:-) Karel -- Karel Zak http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz