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 thing
is that you can formatting interval to strings that seems like
standard time (15:10:33), etc.
The to_interval() will have another (you wanted) behaviour.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
