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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/