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.
Third, why do you have to write "HH24"? Surely no one would want to write
out intervals using a 12-hour clock?
--
Peter Eisentraut peter_e@gmx.net