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 <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
