Re: Timestamp, fractional seconds problem - Mailing list pgsql-hackers

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