Re: Timestamp/Interval proposals: Part 2

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

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz