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 likeeach 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@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/