Re: Formatting intervals..

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  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/