Re: [SQL] Timestamp output

From: Thomas O'Dowd <tom(at)nooper(dot)com>
To: Barry Lind <barry(at)xythos(dot)com>
Cc: Andreas Joseph Krogh <andreak(at)officenet(dot)no>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [SQL] Timestamp output
Date: 2002-03-05 02:13:21
Message-ID: 20020305111321.H1200@beast.uwillsee.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-sql

On Thu, Feb 28, 2002 at 06:32:54PM -0800, Barry Lind wrote:
> Andreas,
>
> I can't reproduce the problem you are seeing. I created a table 'test'
> with one column of type timestamp. Inserted one row with the value from
> now(). And then ran a simple jdbc program to select out that one row.
> This all worked without errors.
>
> Again I ask are you using the latest 7.2 driver? I know there where
> some bugs in earlier 7.2 drivers (I think in all of the betas actually)
> that look similar to the problem you are reporting.

Yep, that should definately be fixed in the latest 7.2 driver. Also,
there is a patch waiting to fix a different timestamp bug which I
submitted on Thu, 17 Jan 2002 22:57:08 which fixes the usage of
timestamp without the timezone.

Tom.
--
Thomas O'Dowd. - Nooping - http://nooper.com
tom(at)nooper(dot)com - Testing - http://nooper.co.jp/labs

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Anthony Kwok 2002-03-05 03:35:26 Need Latest patched driver
Previous Message Barry Lind 2002-03-05 01:32:46 Re: [HACKERS] JDBC: java.sql.SQLException: results returned

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-03-05 02:36:10 Re: Uniqueness of rule, constraint, and trigger names
Previous Message Tom Lane 2002-03-04 23:16:33 Re: Changing sequence cache