Re: Timestamp, fractional seconds problem

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Laurette Cisneros <laurette(at)nextbus(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Timestamp, fractional seconds problem
Date: 2001-10-04 18:00:22
Message-ID: 3BBCA3B6.DE5EA717@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

Laurette Cisneros wrote:
>
> Could I get some more specific information on how this is fixed. Keep in mind that using tochar() is not an option for us in that we ned to use COPY to/from the client.

I'm finishing up implementing SQL99-style precision features in
timestamp et al, so there will no longer be an arbitrary rounding of
time to 2 decimal places when values are output. There will of course be
*other* issues for you to worry about, since the default precision
specified by SQL99 is zero decimal places...

- Thomas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-10-04 18:03:13 Unhappiness with forced precision conversion for timestamp
Previous Message Thomas Lockhart 2001-10-04 17:57:59 Re: pgsql/src/backend parser/parse_coerce.c utils/ ...

Browse pgsql-jdbc by date

  From Date Subject
Next Message Heitzso 2001-10-04 18:29:03 Re: JDBC 2.0
Previous Message Laurette Cisneros 2001-10-04 17:46:10 Re: Timestamp, fractional seconds problem