Re: Timestamp/Interval proposals: Part 2

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