On Wed, Oct 03, 2001 at 05:02:59PM -0700, Laurette Cisneros wrote:
> A work around for display might be to use to_char().
In 7.2 is possible use millisecond / microsecond format:
# select to_char(now()+'2s 324 ms'::interval, 'HH:MM:SS MS'); to_char
--------------10:10:59 324
(1 row)
# select to_char(now()+'2s 324 ms 10 microsecon'::interval, 'HH:MM:SS US'); to_char
-----------------10:10:03 324010
(1 row)
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