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/