Truncation bug when retrieving timestamps with fractional seconds (PG 7.3)

From: Rhett Sutphin <rhett-sutphin(at)uiowa(dot)edu>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Truncation bug when retrieving timestamps with fractional seconds (PG 7.3)
Date: 2003-01-10 20:58:51
Message-ID: 52802DFD-24DE-11D7-91AA-000393BA42B0@uiowa.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I believe I've discovered a bug in the JDBC implementation that ships
with PostgreSQL 7.3: When loading a timestamp, the fractional seconds
may be truncated. Specifically, if there are more than three
fractional digits, they are truncated to three. If there are three or
two, they are truncated by one. If there is one, it is left alone.

Attachment Content-Type Size
Postgresql73TimestampBug.java text/plain 2.3 KB

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Hale Pringle 2003-01-10 23:45:43 Select * from users WHERE upper(lastName) = upper('Pringle')
Previous Message V. Cekvenich 2003-01-10 20:23:23 Re: RowSet