Re: Timestamp, fractional seconds problem

This is very good news. Thanks to all for the response.

L.
On Thu, 4 Oct 2001, Karel Zak wrote:

> 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
>
>

--
Laurette Cisneros
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Passenger Information Everywhere