On Mon, Jun 10, 2002 at 07:18:44PM +0200, Hannu Krosing wrote:
OK, I add to_interval() to may TODO (but it's unsure for 7.3).
> hannu=# select to_char('33s 15h 10m 5months'::interval, 'YYYY.MM.DD
> HH24:MI:SS');
> to_char
> ---------------------
> 0000.05.00 15:10:33
> (1 row)
I think, we can keep this behaviour for to_char(), the good thingis that you can formatting interval to strings that
seemslikestandard time (15:10:33), etc.
The to_interval() will have another (you wanted) behaviour.
Karel
-- Karel Zak <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz