> > 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 <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
