Re: Timestamp, fractional seconds problem

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