> > I'm _sure_ that to_char() is there for interval.
> >
> > testt=# select to_char('33s 15h 10m 5month'::interval, 'HH:MI:SS Month');
> > to_char
> > --------------------
> > 03:10:33 May
> > (1 row)
>
> Does "May" make sense for an _interval _ ? (Feb 22 + May = Jul 22)?
>
> Would not "5 months" make more sense ?
to_char() convert interval to 'tm' and make output like this struct,I don't know what other is possible do with it.
> Or is it some ISO standard ?
>
> Ditto for 15h -> 03 .
HH vs. HH24
test=# select to_char('33s 15h 10m 5months'::interval, 'HH24:MI:SS Month'); to_char
--------------------15:10:33 May
Karel
-- Karel Zak <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz