Re: Formatting intervals..

On Fri, Mar 21, 2003 at 11:05:32AM +0100, Peter Eisentraut wrote:
> Karel Zak writes:
>
> > test=# select to_char('3month 15d 4h 10m'::interval, 'DD-Mon HH24:MI:SS');
> > to_char
> > -----------------
> > 15-Mar 04:10:00
>
> This doesn't seem correct. First, you can't make "March" out of "3
> months". Second, 3 months, 15 days and some hours after the start of the
> year (if that definition were valid, which it isn't) is on March 16.

The interval_to_char() calls interval2tm() and from 'tm' creates output like
each other to_char() function.

You can try to write better interval2tm() for fix it. I haven't time for this now.

> Third, why do you have to write "HH24"? Surely no one would want to write
> out intervals using a 12-hour clock?

select to_char('5d 13h 10m 5s'::interval, 'HH or HH24:MI:SS');
to_char
----------------
01 or 13:10:05

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/